Use `XLOOKUP` to find a value in a range and return a matching result
Use `VLOOKUP` to search the first column of a table and return data from another column
Use `HLOOKUP` to search the first row of a table and return data from another row
Use `INDEX` and `MATCH` together for flexible lookups
Use `LOOKUP` for simple approximate matches
Use `FILTER` to return all matching records
Use `MATCH` to find the position of a value in a range
Use `IFERROR` to handle lookup errors
Make sure the lookup value and lookup range have the same data type
Use exact match when you need a precise result
Use approximate match when working with sorted data and ranges
Lock lookup ranges with `$` when copying formulas
Check for extra spaces or hidden characters in the data
Use named ranges to make lookup formulas easier to read
Use tables to keep lookup ranges dynamic
Verify column or row indexes when using `VLOOKUP` or `HLOOKUP`