Sorry let me try again.

Sheet1: Records
Column1: Name | Column2: OriginCountry
Japanese Doctors Association |
English Breakfast Tea |
American Cheese |

Sheet2: Data
Column1: Country | Column2: Denonym
Japan | Japanese
America | American
British | England
English | England
Maltese | Malta

So now I want to put a formula in Sheet 1/Column 2 that steps through
Sheet2:Column2(Denonym) and if it finds a match updates the value for
Sheet2:Column1 (Country)



"Glenn" wrote:

msnyc07 wrote:
I have a function whereby if a string in Sheet 2/Column1 is contained in
Sheet1/Column1, it returns Sheet2/Column1. I am doing this manually but
would like it to step through the whole table in Sheet 2 (i.e. step through
all for a match.

Currently my formula looks like this;
=IF(ISNUMBER(SEARCH(Sheet2!B3,Sheet1!A3)), Sheet2!A3)

To get it do do each manually of course I'd need to to

=IF(ISNUMBER(SEARCH(Sheet2!B1,Sheet1!A1)), Sheet2!A1,
IF(ISNUMBER(SEARCH(Sheet2!B2,Sheet1!A1)), Sheet2!A2),
=IF(ISNUMBER(SEARCH(Sheet2!B3,Sheet1!A1)), Sheet2!A3), etc

So I am trying to do the same thing manually.

I have played with VLoopup and Index but am only frustrating myself :)


This is a little hard to follow, but probably not that hard to accomplish if you
could show some sample data and expected results. Also, where you want to put
this formula would be helpful.
.