Look up a value to the left or in any column with the flexible INDEX/MATCH combo.
Copy this formula
=INDEX(C:C, MATCH(A2, B:B, 0))MATCH finds the row position of A2 within column B, and INDEX returns the value at that position in column C. Unlike VLOOKUP, the lookup column can be to the right of the return column.
=INDEX(Prices, MATCH(A2, Products, 0))→$19.90Returns the price aligned to the matched product.
It's more flexible (can look left) and doesn't break when columns are inserted. In Excel 365, XLOOKUP does the same more simply.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.