Match columns and bring back a third column
Closed
Alex
-
May 19, 2010 at 10:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 20, 2010 at 11:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 20, 2010 at 11:06 AM
Related:
- Match columns and bring back a third column
- Display two columns in data validation list but return only one - Guide
- Music match jukebox - Download - Audio playback
- Mw2 cant find match ✓ - Video Games Forum
- How to convert row to column in notepad++ ✓ - Excel Forum
- Excel intersection of two columns - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 19, 2010 at 04:45 PM
May 19, 2010 at 04:45 PM
Can you add a new column in Sheet2 which shows the cosolidated value of column A and B ? Some thing like
=A2 & "|" & B2 ?
=A2 & "|" & B2 ?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 20, 2010 at 11:06 AM
May 20, 2010 at 11:06 AM
If you have added that column after the column C on sheet2, then you can use
=IF(ISERROR(MATCH(A2 & "|" & B2, Sheet2!D:D,0)), "", INDIRECT("Sheet2!C" & MATCH(A2 & "|" & B2, Sheet2!D:D,0)))
This assumes that you have added the formula in D column of sheet2
You could also use VLOOKUP but for that, the condition is that newly added column appear before the value that is be to returned, (so inyou sample the column C needs to be moved one column to right ( to column d)
Again assumption is that you have used formula A2 & "|" & b2
=IF(ISERROR(MATCH(A2 & "|" & B2, Sheet2!D:D,0)), "", INDIRECT("Sheet2!C" & MATCH(A2 & "|" & B2, Sheet2!D:D,0)))
This assumes that you have added the formula in D column of sheet2
You could also use VLOOKUP but for that, the condition is that newly added column appear before the value that is be to returned, (so inyou sample the column C needs to be moved one column to right ( to column d)
Again assumption is that you have used formula A2 & "|" & b2
May 20, 2010 at 04:17 AM
Thanks for your help but unfortunately this is not the solution to my query.. I want to compare columns a&b in sheet1 with columns a&b in sheet2 and if they are the same bring back the data from column c in sheet2 into column d in sheet1.
Do you have a solution for this query.
Alex
May 20, 2010 at 05:15 AM
May 20, 2010 at 10:49 AM
My apologies I picked you up wrong. I have setup your formula in column of sheet2.
Alex