Combining INDEX and MATCH is more versatile than VLOOKUP as you can do things like have the result you return to the left of the value you're looking up. However, VLOOKUP / HLOOKUP are simpler to understand when starting out, and that's a good thing when you're trying to build confidence in using Excel.
Comments
Combining INDEX and MATCH is more versatile than VLOOKUP as you can do things like have the result you return to the left of the value you're looking up. However, VLOOKUP / HLOOKUP are simpler to understand when starting out, and that's a good thing when you're trying to build confidence in using Excel.