Compare values in two columns and return the value from third
Solved/Closed
ramdubai
Posts
2
Registration date
Monday March 11, 2013
Status
Member
Last seen
March 11, 2013

Updated on Jan 13, 2019 at 11:28 AM
keshav  Sep 7, 2016 at 02:30 AM
keshav  Sep 7, 2016 at 02:30 AM
Related:
 If two cells match return value from third excel
 Formula to see if two cells match  Best answers
 Formula to check if two cells match  Best answers
 If cell contains (multiple text criteria) then return (corresponding text criteria) ✓  Excel Forum
 Excel if range of cells contains specific text then return value ✓  Excel Forum
 Excel if cell contains date then return value ✓  Office Software Forum
 Excel conditional formatting if another cell contains specific text ✓  Excel Forum
 Excel date format dd.mm.yyyy  Guide
4 replies
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Mar 11, 2013 at 02:57 AM
Mar 11, 2013 at 02:57 AM
Hi ramdubai
Are the criteria values unique! If they are, try the following. assuming your data is in A1:C100 including column headers.
=LOOKUP(2,1/((A2:A1000=Value1)*(B2:B1000=Value2)),C2:C1000)
If there are multiple criteria which match, then try the array formula ("ctrl + shift + enter" to commit)
=IFERROR(INDEX($C$2:$C$1000,SMALL(IF(($A$2:$A$1000=Value1)*($B$2:$B$1000=Value2),ROW($2:$1000)ROW($1:$1)),ROW($A1))),"")
Kevin
Are the criteria values unique! If they are, try the following. assuming your data is in A1:C100 including column headers.
=LOOKUP(2,1/((A2:A1000=Value1)*(B2:B1000=Value2)),C2:C1000)
If there are multiple criteria which match, then try the array formula ("ctrl + shift + enter" to commit)
=IFERROR(INDEX($C$2:$C$1000,SMALL(IF(($A$2:$A$1000=Value1)*($B$2:$B$1000=Value2),ROW($2:$1000)ROW($1:$1)),ROW($A1))),"")
Kevin
Mar 2, 2014 at 02:18 PM
I have a similar question please..
Mar 2, 2014 at 02:29 PM