Vlookup for duplicate values

  • Hi,
    Need some one help
    I have large data where i have to apply VLOOKUP on sheet 1 to bring values from Sheet2 with similar references. The problem i have is there are duplicates values in sheet2 against same references and what i want is that it should add values of all duplicates and bring one figure on sheet 1.


    Thanks a lot in advance

  • Re: Vlookup for duplicate values


    If they are all values, you can use the SUMIF formula.
    =SUMIF("Range of references from sheet2","lookup reference from sheet1","Range of values from sheet2")

    Regards,


    WidgetWonka
    Puuuureeee Imagination

  • Re: Vlookup for duplicate values


    Thats work perfect....Thanks
    Just need to add something in this formula if possible
    =SUMIF("Range of references from sheet2","lookup reference from sheet1","Range of values from sheet2") as currently it add up values of one colum from sheet 2, can i give a range of multiple columns from sheet 2 to be added?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!