Lookup within a Lookup

carl-barratt

New Member
Joined
Nov 17, 2005
Messages
9
I have a speadsheet that needs to look at two cells then make them match up and return a result. Very similar to a standard lookup but by adding an additional cell to match before returning the reuslt.

Must match a and b then look at a speadsheet and match them up and return a result in that cell.

Thanks for your help

Carl
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Possibly this sort of array formula

=INDEX($C$1:$C$10,MATCH(1,($A$1:$A$10=D1)*($B$1:$B$10=E1),0))

confirmed with CTRL+SHIFT+ENTER

where you are looking for the value in column C where column A matches D1 and column B matches E1
 

Watch MrExcel Video

Forum statistics

Threads
1,118,088
Messages
5,570,144
Members
412,306
Latest member
fabio6
Top