Combining the INDEX Function Formula with MATCH Function Formula In Excel
INDEX Function Formula With MATCH Function Formula
need to specify more complex conditions when writing your formula in Excel. You can combine the INDEX function Formula with MATCH functions Formula
This Function Formula is Most Useful to Reverse LOOKUP Find, Look like Similar to VLOOKUP Function Formula, VLOOKUP Find Right Side Column Value and INDEX With MATCH Function Formula Find Left Side Column Value
For Example :
A B C D
Qty Product Name Product Name Qty (Result)
5854 Saree Tunic 552
8582 Dress Material Shirt 2524
2854 Tops Saree 5854
2524 Shirt Dress Material 8582
552 Tunic Tops 2854
INDEX With VLOOKUP Function Formula is
=INDEX(A:A,(MATCH(C:C,B:B,0)))
=INDEX(A:A,(MATCH("Shirt",B:B,0))) For Use Only one Individual Data Find
need to specify more complex conditions when writing your formula in Excel. You can combine the INDEX function Formula with MATCH functions Formula
This Function Formula is Most Useful to Reverse LOOKUP Find, Look like Similar to VLOOKUP Function Formula, VLOOKUP Find Right Side Column Value and INDEX With MATCH Function Formula Find Left Side Column Value
For Example :
A B C D
Qty Product Name Product Name Qty (Result)
5854 Saree Tunic 552
8582 Dress Material Shirt 2524
2854 Tops Saree 5854
2524 Shirt Dress Material 8582
552 Tunic Tops 2854
INDEX With VLOOKUP Function Formula is
=INDEX(A:A,(MATCH(C:C,B:B,0)))
=INDEX(A:A,(MATCH("Shirt",B:B,0))) For Use Only one Individual Data Find