Exchange rate table
An exchange rate is given for each currency, within each month’s data rage
Project details tables
Shows the project start date and currency
I’m trying to write a script that:
Looks at each project ID, its currency and start date...
Thanks Kuvonne,
I’m seeking help to update the script I repurposed from Greg Vonf’s excellent post. The updates summarised are:
lookup two criteria (instead of one)one lookup matches a lookup date to a date range
Here’s the code with the formatting m...
