Forum Discussion

Copper Contributor

Sep 24, 2020

Merge and allocate in Excel

Hi Information: I'm using Excel 2010, there are 1000+rows. I have 2 excel sheets and I have reducted the needed Data down to 3 different ones. On sheet 1, I have in column A all the product "NAM...

excel

Formulas and Functions

training

Bennadeau

Iron Contributor

Sep 24, 2020

Hi Uguey,

If your sheet1 and sheet2 have the exact same names in your "NAMES" column, how about you simply sort them in alphabetical order, copy the weight column from sheet2 and paste it to sheet1?

This will work fine if and only if you have the exact same NAMES column in both sheet.

Uguey

Copper Contributor

Sep 24, 2020

Thanks, I forgot to mention that the NAMES are the same but some only appear only in sheet1 and some only in sheet2, that's why I'm asking for a possibility to auto-allocate.
I'm sorry for the missing information.

Bennadeau
Iron Contributor
Sep 24, 2020
Uguey,

In this case, can't you use vlookup?
=VLOOKUP(A2,Sheet2!A:B,2,0)