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

[FloopDirect1295]

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 · Accepted solution]

@FloopDirect1295 

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

[#3]

this worked!! thank you!