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

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

Pete

On Apr 21, 10:06*pm, Graham wrote:
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