Multiple Lookup Values

Multiple Lookup Function in Excel

This formula performs a lookup operation in Excel and retrieves all matching values, unlike the VLOOKUP function which returns only a single result.

This formula in Excel allows you to perform a lookup operation and retrieve all the matching values instead of just one. It searches a specified range of cells for a given value and returns all the corresponding results from another range of cells. This feature is particularly useful when you need to gather multiple matches from your data, providing a comprehensive view of the results in a single formula.

Watch below video to see how to use the same

 

Watch below video to see how to activate it in your Excel