Forum Discussion
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 Sheet 2, Column C contains the platform the products run on. I'd like to bring the data from Sheet 2 Column C into Sheet 1 for one master file with all the information. Any help to match the values in both Columns A to the respective value in Sheet 2 Column C would be greatly appreciated!
=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.
2 Replies
=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!
