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
Lookup function help required. 0
Table Lookup 4
Dealing with the error: unable to filter on excel hc home school 0
Concatenate, currency & sum formula 2
Data Validation - Complex Q 2
Use TODAY() function as the criteria in a SUMIF formula 1

Top