Need help to use VLOOKUP

Christian Jade 0 Reputation points
2026-09-19T01:31:30.7466667+00:00

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.
Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Oldest
Most helpful Newest Oldest
  1. Kien 1,545 Reputation points Independent Advisor
    2026-09-19T01:48:54.5766667+00:00

    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.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.