SOLVED

Match One Column from 2 Tabs to Return Info from 3rd

Copper Contributor

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!

2 Replies
best response confirmed by FloopDirect1295 (Copper Contributor)
Solution

Re: Match One Column from 2 Tabs to Return Info from 3rd

=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.

Re: Match One Column from 2 Tabs to Return Info from 3rd

this worked!! thank you!
1 best response

Accepted Solutions
best response confirmed by FloopDirect1295 (Copper Contributor)
Solution

Re: Match One Column from 2 Tabs to Return Info from 3rd

=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.