Multiple Criteria Lookup while Working With Number

  • Hello OzGrid,


    I am trying to formulate to find out lookup a value to two criterias. One of them is number (0,1,2... etc as unit of weight). And the other one is gathered from numbers again but headers stored as text (company names). Desired result is included in the Excel Workbook here. Thanks in advance.

    Files

    • test.xlsx

      (9.06 kB, downloaded 174 times, last: )

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke
    [/SIZE]

  • How about

    =INDEX(H5:K12,MATCH(G18,G5:G12,0),MATCH(H18,H4:K4,0))

    although I think the result should be 16 not 46

    Hello Fluff13. Thank you very much. This is what I am looking for. Yeah, that is correct. It was 16. Thanks again.

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke
    [/SIZE]

  • Fluff is right ....:)


    In addition ... Excel is designed to make your life a lot easier .... see your test file attached ;)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Fluff is right ....:)


    In addition ... Excel is designed to make your life a lot easier .... see your test file attached ;)

    Ah Yes. I don't know how I missed that one. Thank you very much you, too, Carim. :)

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke
    [/SIZE]

  • You are welcome :)


    Thanks for your Thanks ...AND for the Like :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)