9. INDEX and MATCH: INDEX and MATCH can be used together to look up a value in a table and return a value from another column based on a match. This is a more powerful alternative to VLOOKUP and HLOOKUP in some cases.
By
–
9. INDEX and MATCH: INDEX and MATCH can be used together to look up a value in a table and return a value from another column based on a match. This is a more powerful alternative to VLOOKUP and HLOOKUP in some cases.