May 02 2022 03:09 PM
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.
May 02 2022 03:16 PM
SolutionMay 02 2022 03:16 PM
Solution=VLOOKUP($D2,'File A'!$A$2:$C$15,COLUMN(B:B),FALSE)
Maybe with this formula.