Forum Discussion
Merging Tables
I have two sheets. Sheet2 has 1741 rows and Sheet1 has 324. Sheet1 column A has id numbers that all exist in Sheet2 column D. I want to append the text cells (Columns $B:$H) from sheet1 to the matchi...
=VLOOKUP($D2,sheet1!$A$2:$H$324,COLUMN(B:B),FALSE)This formula works in my sheet. An alternative could be INDEX and MATCH.