The exact formula you put in A1 of Sheet3 is this:
=VLOOKUP(Sheet1!$A1,Sheet2!$A$1:$G$90000,COLUMN(B1)-1,0)
Once it is entered, you copy and paste it out to column G, and down to row 15000.
The exact formula you put in A1 of Sheet3 is this:
=VLOOKUP(Sheet1!$A1,Sheet2!$A$1:$G$90000,COLUMN(B1)-1,0)
Once it is entered, you copy and paste it out to column G, and down to row 15000.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks