Advance Vlookup in Microsoft Excel

Learn the uses of Vlookup function in advanced way. This tutorial shows "How to pickup the value depending on two lookup value criteria using Vlookup function".

how to pick the values depending on the lookup values criteria using “Vlookup” to pick up

[saadharoub]

Thanks Sir, It's very useful knowledge

[ShaluSingh-jbqq]

It's really helpful with good clarity....

[manassss]

Really helpful also for those who really used MS excel tool.

[Alhusam]

Thanks. The idea of the helper column is very clever if there is no other way around. I understood that from your answer to the question by @Gn Billing.

[gnbilling]

Helpful. What is the purpose of adding the helper column?

[sandyweigens]

It's nice to see that the first column in the data table no longer has to be sorted in ascending order.

[e.Gohary]

You can make the vlookup work even if the lookup value is located in any column not only the first one.

[tutac.]

nice alternative, but for this example the SUMPRODUCT is a simplerand better solution