Compare values in two columns and return the value from third
Solved/Closed
ramdubai
keshav - Sep 7, 2016 at 02:30 AM
- Posts
- 2
- Registration date
- Monday March 11, 2013
- Status
- Member
- Last seen
- March 11, 2013
keshav - Sep 7, 2016 at 02:30 AM
Related:
- Formula to see if two cells match
- If two cells match then return value - Best answers
- Excel match two columns and output third - Best answers
- Excel - IF is error with 2 cells match - How-To - Excel
- How to perform a partial cell match in Excel? - Guide
- Excel formula based on color of cell - Guide
- Excel function to Check neighbour cells match for all ✓ - Forum - Excel
- Any part of string in cell matches part of string in another ✓ - Forum - Excel
4 replies
Kevin@Radstock
Mar 11, 2013 at 02:57 AM
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
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
Mar 3, 2014 at 12:39 AM
Perhaps something along these lines.
=IF(A1=B1,C1,"")
Sep 7, 2016 at 02:30 AM
if i have a column a and in column we have two or more same no.(like ab-230,ab-230),randomaly. i want to search them and add there value.
ex:
A B C
ab-230 2 4
an-25 4 7
ab-230 3 6
we want to add column a like
A b C
ab-230 5 10
pls reply me
Aug 28, 2015 at 02:00 PM