Recursively using VLOOKUP

  • Thread starter Thread starter SteveT
  • Start date Start date
S

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
 
Back
Top