Forum Discussion
Solved
Match One Column from 2 Tabs to Return Info from 3rd
Hello! I am trying to figure out a way to match columns on separate sheets to return information from a 3rd column on the second sheet. In Sheets 1 and 2, Column A contains a list of products. In She...
=INDEX(Sheet2!$C$2:$C$100,MATCH(Sheet1!A2,Sheet2!$A$2:$A$100,0))
=VLOOKUP(A2,Sheet2!$A$2:$C$100,3,FALSE)
If the data in Sheet 1 Column A starts in cell A2 you can enter one of these formulas in cell B2 of Sheet 1 and fill it down as required.
=INDEX(Sheet2!$C$2:$C$100,MATCH(Sheet1!A2,Sheet2!$A$2:$A$100,0))
=VLOOKUP(A2,Sheet2!$A$2:$C$100,3,FALSE)
If the data in Sheet 1 Column A starts in cell A2 you can enter one of these formulas in cell B2 of Sheet 1 and fill it down as required.
this worked!! thank you!