# 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