# 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

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

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

although I think the result should be 16 not 46

=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

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