VLOOKUP two variables

[JohnF]

I have a spreadsheet with the following

Column A, Row 1 = 000208
Column B, Row 1 = GL001
Column C, Row 1 = Blue (or some other colour)

I want to use a VLOOKUP to look for 000208 and GL001 and give me the entry in Column C Row 1, Can this be done.

Thanks

 

[Brian from Maui]

I have a spreadsheet with the following

Column A, Row 1 = 000208
Column B, Row 1 = GL001
Column C, Row 1 = Blue (or some other colour)

I want to use a VLOOKUP to look for 000208 and GL001 and give me the entry in Column C Row 1, Can this be done.

Thanks

In another empty column, concatenate column A and B using,

=A1&CHAR(127)&B1 and drag down, then use,

=INDEX(C1:C100,MATCH(E1&CHAR(127)&F1,D1:D100,0))

Where E1 and F1 would house your criteria to lookup. And D1:D100 is the column you used for concatenating A and B.

 

[JohnF]

It Works

Thanks Brian. It works a treat.