Need help to use VLOOKUP

Question

I am working on an Excel file for my company. I use Excel to maintains product prices in a Product Master table located in cells A5:D14. The columns are Product ID, Product Name, Category, and Unit Price.

In the Sales Orders sheet, the Product ID is entered in cell C5 and the Quantity is entered in cell D5.

Please help me to write formulas using VLOOKUP to:

• Retrieve the Unit Price based on the Product ID.
• Display “Product not found” if the Product ID does not exist.
• Calculate the total Revenue for the order.

Answer 1

Dear Christian Jade,

To ensure I understand your request correctly and to support you as effectively as possible, I need more specific information from you:

• Could you provide the Excel file or screenshot it?

In the meantime, based on your description, kindly try these steps:

For the unit price formula:

=IFERROR(VLOOKUP(C5,'Product Master'!$A$5:$D$14,4,FALSE),"Product not found") 

For the revenue formula:

=IF(ISNUMBER(E5),D5*E5,"")

I hope the information shared helps point you in the right direction.