Method 2 – Easy horizontal lookup using INDEX, SMALL, and IF functions for quick data retrieval. To demonstrate how to use VLOOKUP to return multiple values using INDEX, SMALL, and IF from data in ...

Press Enter.; Let’s explain what this formula does: F2&G2 – Represents cells that we use for lookup values. Cells are separated by & indicating that we’re looking for multiple values. A2:A5&B2:B5 – ...

The MATCH function returns the position of a value (in a list, table, database). And, the INDEX-MATCH functions used together make extracting data from a table a breeze.

Functions that return multiple values are hard to name clearly. It's easy to mistake the order of the return values. (password, username) = GetUsernameAndPassword() ...