Recursively using VLOOKUP

[SteveT]

Hi,

Wonder if anyone can help me. The deal is I have two sheets in a boo
one called TABLE_ROWS the other called TABLES (they store databas
table information). I currently use VLOOKUP to lookup a table name an
populat a cell. Using:

=VLOOKUP(Tables!B872, Table_Rows!B$2:C$10000,2,FALSE)

It all works fine but I've noticed recently that some values don't ge
picked up right. The reason very simply that I have values in the B87
column that aren't unique. For example I have in Tables!B an Tables!
columns with the following data:

Tables!A Tables!B
MYSCHEMA1 TEST
MYSCHEMA2 TEST

So my VLOOKUP needs to look at column "A" first, find a match and the
look at column "B". How can I do this? I've look at VLOOKUP's an
MATCH but am stuck....

Any help would be fantasti

 

[Frank Kabel]

Hi

have a look at
http://www.mvps.org/dmcritchie/excel/vlookup.htm

at the bottom of this page a 'double lookup' is described

HTH
Frank

 

[SteveT]

Frank this works a treat, many thanks!!!!

Stev