I am preparing a currency worksheet. My source sheet does not use the
exact same name each time I load the data (I have it set up to
automatically refresh the data on open). However, one thing that is
consistent in the data EVERY time is the name of the country. As a
result, I have to set up my lookup formula accordingly.

For instance, the raw data will say: United States Dollar to
Australian Dollar. The next time it is loaded it might say:
Australian Dollar to United States Dollar. There are about 50
currencies like this. Let's assume that the raw data is in the
following range: 'Raw Data'!A:B. Column B has the conversion rates.
The sheet I am using to filter the data will be set up like this:

Country Abbreviation Lookup
Australian AUD ='find A2 in 'Raw Data'!A:B and
return the row number
British GBP
Czech CZK
Danish DKK

etc.

The problem I run into is that the words I am looking for are not
WHOLE cells on the raw data sheet. Any help is much appreciated.
Thanks.

Kevin