Using look-up tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to use a look-up table by referencing two cells. For example, I would like to use the VLOOKUP function, but I need to have the function find a match for two cells instead of one. I want it to return the number in column 3 where both column 1 and column 2 match the defined criteria. I appreciate your help.
 
Mike Parker said:
Is there a way to use a look-up table by referencing two cells. For
Click to expand...
example, I would like to use the VLOOKUP function, but I need to have the
function find a match for two cells instead of one. I want it to return the
number in column 3 where both column 1 and column 2 match the defined
criteria. I appreciate your help.

This array formula looks up D1 in column A and E1 in column B, returning
column C value corresponding to first double match. As it is an array
formula, it must be entered using CTRL+SHIFT+ENTER rather than just ENTER.
=INDEX($C$1:$C$100,MATCH(1,($A$1:$A$100=D1)*($B$1:$B$100=E1),0))
 
See the answer to your question named "Vlookup with 2 reference cells"

Mike Parker said:
Is there a way to use a look-up table by referencing two cells. For
Click to expand...
example, I would like to use the VLOOKUP function, but I need to have the
function find a match for two cells instead of one. I want it to return the
number in column 3 where both column 1 and column 2 match the defined
criteria. I appreciate your help.
 
Back
Top