Forum Discussion

Uguey's avatar
Uguey
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's avatar
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's avatar
    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's avatar
      Bennadeau
      Iron Contributor
      Sep 24, 2020

      Uguey,

       

      In this case, can't you use vlookup?

      =VLOOKUP(A2,Sheet2!A:B,2,0)

       

       

Resources