I would like to be able to find matches between two columns in Excel. Lets say Column A and Column C. However Column A's values are linked to Column B. When a match is found in A, can it copy the corresponding row value from B into another sheet?
Excel- find match between to columns but copy a different cell
microsoft excelworksheet-function
Related Solutions
LOOKUP is fine as long as B1 exists in F1:F39 (and because F1:F39 is sorted ascending), but what if B1 is 120? Your formula will return 113-Campaign Implementation. If you want #N/A in that case (as you would get with your MATCH function) then better to use VLOOKUP, i.e.
=VLOOKUP(B1,$F$1:$G$39,2,FALSE)
...or you can use INDEX with your MATCH, i.e.
=INDEX($G$1:$G$39,MATCH(B1,$F$1:$F$39,0))
This can be done without changing the original data layout or joining any data. You can use an Index/Match combo like this:
=IFERROR(INDEX(Sheet2!$C$1:$C$10,MATCH(Sheet1!C2+Sheet1!D2,INDEX(Sheet2!$A$1:$A$10+Sheet2!$B$1:$B$10,0),0)),"")
Best Answer
Let's say you have the following data in 'Sheet 1':
Col A ; Col B ; Col C
1 ; 131 ; 3
2 ; 125 ; 5
3 ; 168 ; 2
4 ; 154 ; 8
5 ; 1365 ; 0
If I understand the requirement of your question correctly, use the following formula in the sheet you want to have your corresponding value appear: