Formula using INDEX and MATCH. So in this case we need sales values so choose the range of cells from B2 to G11. After executing the macro we will get the output in cell H2 This is how we can get results using Index Match worksheet function in VBA.
Introduction to Match Multiple Criteria in Excel Being a data analyst you always need to deal with multiple criteria and conditions in order to get the desired result.
Heres the revised formula with the MATCH function nested inside INDEX in place of 5. The array formula above looks up the salary of James Clark not James Smith not James Anderson. Open the INDEX function in cell B15. We will go about this in 2 steps.