How do I use the Excel Formula To Fetch Price From A Lookup Table formula?

Paste the formula into the first output cell, then fill down to apply it to your range.

Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Fetch price from a lookup table with a ready-to-use formula for Excel, Google Sheets, and WPS.

Fetch price from a lookup table.

=XLOOKUP(E2, A:A, B:B, "Not found")

View platform differences

Google SheetsWPS

=IFERROR(VLOOKUP(E2, A:B, 2, FALSE), "Not found")

Lookup price from another table with a ready-to-use formula for Excel, Google Sheets, and WPS.

Lookup price from a lookup table with a ready-to-use formula for Excel, Google Sheets, and WPS.

Lookup price from sheet2 with a ready-to-use formula for Excel, Google Sheets, and WPS.

Lookup price from a master list with a ready-to-use formula for Excel, Google Sheets, and WPS.

Lookup price table Sales with a ready-to-use formula for Excel, Google Sheets, and WPS.

Lookup price table Orders with a ready-to-use formula for Excel, Google Sheets, and WPS.