Help with lookup formula

G

Graham

If one of the countries in a named list "OECS" is found in H10, lookup the
relavant worksheet and return a rate based on the currecy in AG10. If H10
contains a different country (e.g. Canada) lookup the relavant worksheet and
return a rate also based on the currency and so on. All the OECS use the same
currency rate. How do I write this formula.

Thanks
 
P

Pete_UK

What do you mean by "relevant worksheet"? Do you have a sheet call
"Canada"? Please give a bit more detail.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fomula which returns the amount depending on the currency code 3
making a portion of reference to a worksheet variable in a formula 1
Help needed 0
CONCATENATE & LOOKUP Functions 0
Table Lookup 4
Formula to input value 4
Lookup formula 2
Time calculations for Scheduled vs Actual Employee Time and Wages 4

Top