Back to Excel Tips Index

1. Create a column in your Lookup table and concatenate the values you wish to look up (must be the column furthest to the left of the data to return if using VLOOKUP.)

2. Now you can look up multiple keys using the following formula as an example:

Synt. =VLOOKUP(key_1 & “@” & key_2, Rng_to_Lookup, Col_Ind, [0 or 1])

ex. =VLOOKUP(A1&”@”&B1,Sheet1!A:C,3,0)

Note: There is a “@” in the middle of the two keys/conditions.  This is to avoid errors such as concatenating two different records that form the same value.  For instance 12A and BC equals 12ABC; 12 and ABC equals 12ABC.  Two very different records equal the same key when concatenated.  Using the “@” between the keys helps avoid this error.

Back to Excel Tips Index