vlookup

  • Thread starter Thread starter kevan
  • Start date Start date
K

kevan

I am trying to creat a vlookup formula that will use two
references in the data base to return a single result eg
look for this and this and enter the number in column 6.
Is this possble I can do it fo one but not for two
 
kevan said:
I am trying to creat a vlookup formula that will use two
references in the data base to return a single result eg
look for this and this and enter the number in column 6.
Is this possble I can do it fo one but not for two
Click to expand...

This array formula will look up D1 in column A and E1 in column B, returning
column C value corresponding to first double match. Is this the kind of
thing you want?
=INDEX($C$1:$C$100,MATCH(1,($A$1:$A$100=D1)*($B$1:$B$100=E1),0))

Note that it has to be array-entered: CTRL+SHIFT+ENTER rather than just
ENTER
 
Back
Top