Google Sheets Functions: Lookup
Find the list of all Google Sheets function tutorials on the Functions page.
Lookup Functions
| HLOOKUP | Returns a value from a range based on a value found in the first row. |
| INDEX | Returns a value in a range based on a column and row number. |
| INDEX + MATCH | A combination similar to VLOOKUP and HLOOKUP without the constraint of the first column or row. |
| MATCH | Returns the position of a value in a range. |
| VLOOKUP | Returns a value from a range based on a value found in the first column. |
| XLOOKUP | Searches for a value in a range and returns the value in the same position from another range. |
| XMATCH | Returns the position of a value in a range. |