Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Lookup based on 2 values

  1. #1
    New Member
    Join Date
    Feb 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Lookup based on 2 values

    Hi Excelians,

    I am sorry for being a total noob.

    I wish to look up values from a datasheet (daily report) into a workbook (template).My problem is I need to pick up values based on 2 columns

    I tried an array formula but it didnt work when I closed my template and replaced the daily report. I dont want to concatenate and vlookup because I have to run this report several times and I wish it picks up values automatically from a different workbook (dailyreport) automatically like vlookup does.

    Here is a representation

    Col 1 Col2 Value1 Value2
    Tesco Orange 10 20
    Tesco Mango 10 30
    Tesco Grape 7 -22
    Walmart Mango 1 12
    Walmart Papaya 3 0
    Walmart Pineapple 30 23
    SuperBuy Mango 3 11
    SuperBuy Orange 1 0
    SuperBuy Kiwi 11 1000


    Thanks
    Akhil

  2. #2
    New Member joebbshop's Avatar
    Join Date
    Aug 2009
    Location
    St. Louis, MO
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Lookup based on 2 values


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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