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