Return value with 2 conditions (using Lookup/Match/Index)

V

Venice

I am looking for a formula to return 1 value with 2 criteria. There are 2
excel sheet:
Sheet 1 - Row A (city), Row B (airlines)
Sheet 2 - Row A (airline), Row B (city), Row C (airlines rate)

If in sheet 1, cell A3 Indonesia and flying with SIA Airlines (cell B3), how
can make use Sheet 2 data of Row C with the condition of "Indonesia" and
"SIA"(2 conditions) to pull out the airlines rate.

Any main formula, I've searched through MATCH, VLOOKUP, INDEX, most of them
only cater to 1 look up value condition. Pls help. Thanks.
 
V

Venice

Thanks Jacob. It really works!

May i know what's the purpose of putting "--+ in each of the array?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with 2 Conditions 2
find and copy it.. 2
Advance Lookup Functions 4
Using index and match 5
Confusion with INDEX & MATCH 4
Return cell reference instead of value 1
Complicated Formula 5
Complex match 1

Top