formula assistance

Occasional Contributor

Hello Excel experts.

In File A, I have a sheet with 3 columns.. let's say they are called (ID, Col1, Col2). In File B, I have a sheet with a lot of columns, including a column for the ID. I would like to have the data from Col1 and Col2 in File A, be copied to file B and applied to the corresponding row for the ID that matches File A.  So for example, if file A has ID = 123. I would like the formula to look up ID 123 in File B and insert the data from Col1 and Col2 in that row. 

Any help is most appreciated.

2 Replies
best response confirmed by shockliz (Occasional Contributor)


=VLOOKUP($D2,'File A'!$A$2:$C$15,COLUMN(B:B),FALSE)

Maybe with this formula. 

Thank you very much! This is extremely helpful.