公式库

Excel Formula To Return Category Table Sales

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

快速答案

Return category table Sales.

Excel

=XLOOKUP(E2, A:A, B:B, "Not found")
查看平台差异

统一公式

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

使用说明

需要定制版本？

相关公式

Excel Formula To Lookup Price From Another Table

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

Excel Formula To Lookup Price From A Lookup Table

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

Excel Formula To Lookup Price From Sheet2

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

Excel Formula To Lookup Price From A Master List

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

Excel Formula To Lookup Price Table Sales

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

Excel Formula To Lookup Price Table Orders

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