Match columns and bring back a third column
Closed
Alex
-
19 May 2010 à 10:23
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 May 2010 à 11:06
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 May 2010 à 11:06
Related:
- Match columns and bring back a third column
- Excel column number - Guide
- How to delete a column in word - Guide
- Music match jukebox - Download - Audio playback
- Tweetdeck expand column - Guide
- Excel partial text match between two columns - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
19 May 2010 à 16:45
19 May 2010 à 16:45
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
20 May 2010 à 11:06
20 May 2010 à 11:06
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
20 May 2010 à 04:17
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
20 May 2010 à 05:15
20 May 2010 à 10:49
My apologies I picked you up wrong. I have setup your formula in column of sheet2.
Alex