Results 1 to 3 of 3

Thread: Multiple Lookup excel query

  1. #1

    Multiple Lookup excel query



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

    This has been bugging me for a while now. Essentially what I'd like to do is to check that the Size & Qty match up from one sheet to another, using the unique code as the lookup reference.
    In the attachment, on the tab called 'form', to check the size, you will need to look at the number in column 'I' and then looking between rows 1 & 8, go along until you see the number that you want.
    For example, for code 3053, the size code is 7, & the Qty is 39 under size 'XL'.
    In the tab called 'data', I want it to

    • check that the Customer PO matches in ‘data’ column E & ‘form’ column A
    • check that the code matches in ‘data’ column K & ‘form’ column B
    • Then if they both match, look up the size break in ‘form’ column I, and whatever number that is, do a lookup in ‘form’ rows 1 to 8 to see what volume there is against each code
    • I would like a formula that will paste whatever the size is based on the top 2 criteria in ‘data’ column S & whatever the respective Qty are in col T

    The main difficulty that I’ve found is that because there are sometimes multiple sizes under the same code.

    Please let me know if this doesn’t make sense.
    Attached is the spreadsheet for your reference.
    Many thanks in advance!

  2. #2
    No attachment.

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Please show all links to crossposts in other forums.

    Please also read why we ask: http://www.excelguru.ca/content.php?184


Posting Permissions

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