Forum Discussion
migrating data from one sheet to another
Ive got two Excel files. One we will call file-A and one we will call file-B. I have a column in both sheets called "SKU" and a column called "PRICE". I need to know how to get Excel to search th...
I agree with mathetes procedure, in addition to the formula at step 6 which is
=VLOOKUP(A2,[File-B.xls]worksheet1!A2:B2000,2,0), before you copy this formula down to the remaining 1199 rows you need to fix the formula so the range values are fixed and will not transpose which is =VLOOKUP(A2,[File-B.xls]worksheet1!$A$2:$B$2000,2,0).
By adding a $ sign with the range value, this ensures that the range is fixed for all 1199 rows.
