=VLOOKUP(A2,ExRates,2,FALSE)
or
=IF(ISERROR(VLOOKUP(A2,ExRates,2,FALSE)),"", VLOOKUP(A2,ExRates,2,FALSE))
You could also use VBA to input the value into B2 and have the exchange rates hardcoded into the VBA script or also use the Lookup table.
=VLOOKUP(A2,ExRates,2,FALSE)
or
=IF(ISERROR(VLOOKUP(A2,ExRates,2,FALSE)),"", VLOOKUP(A2,ExRates,2,FALSE))
You could also use VBA to input the value into B2 and have the exchange rates hardcoded into the VBA script or also use the Lookup table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks