Results 1 to 2 of 2

Thread: Help with LOOKUP in a pricelist.

  1. #1

    Question Help with LOOKUP in a pricelist.



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

    Hi, i have som problem to find out how to put togheter a formula .

    A B C D
    2 3 4 5 (Zone)
    1 22 44 66 12 Country: USA Result Zone: 2
    2 33 55 77 13 Weight: 4 kg
    3 44 66 88 14
    4 55 77 99 15 Price: 55 USD
    KG...

    First, i lookup a name in a List ex. USA, and that return a nr. ex. 2 (column, the 2-5)
    Then i want to use that nr. to give me back a price in my list , BUT the lookup must include another nr. (weight,1-4 downwards).. messy..

    In clean text. I get back a "Zone" nr. ex. Zone 2,
    And i also have enter a weight, and i want it to search up that weight in Zone 2 and send back a price in the list...

    SOmething like "Lookup(USA;A2:A5,B2:B5)" Result: Zone 2 ... and i stuck with the rest

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Try it like this.
    Attached Files Attached Files

Posting Permissions

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