Results 1 to 3 of 3

Thread: Macro or lookup function needed

  1. #1

    Macro or lookup function needed



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Champs,

    I have 2 sheets

    1. Data
    2. Lookup values

    i need a function or a macro to get the code details from data sheet from the lookup values sheet. pease help ..

    i Have attached sample file for the reference.sample.xlsx

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try this formula in A2:

    =SUMIFS('lookup value'!$C:$C,'lookup value'!$A:$A,$A2,'lookup value'!$B:$B,B$1)

    copied down and across the table.


  3. #3
    Thank you ... working fine

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •