Excel Order form with Drop-down boxes

Question

I am trying to create an order form where there is a drop down box for the item name.  once the item is selected, I need the part number and price to populate.

I then need to have the customer enter the quantity needed and have the price calculated.

I then need to have a subtotal add up all of the prices.

I am using vlookup for the part numbers and price, but I can't get the subtotal because I get an #N/A error for rows that have not had items selected.

Answer 1

Do you have the DV Dropdown list created?

Do you have the VLOOKUP formulas in place?

Do you have a Subtotal formula?

If all you have left is to prevent the #N/A then wrap the formula with ISNA or IFERROR

A post from Jerry Latham gives a couple of examples.

"wrap" your formula in the Excel 2007/2013 IFERROR() function like this:

=IFERROR(VLOOKUP(),"")

Of course you'd put the full VLOOKUP formula into it.

If there is a chance that you'll be passing the workbook to people who have earlier versions of Excel (2003, XP, 2000), then do it this way:

=IF(ISNA(VLOOKUP()),"",VLOOKUP())

The IF(ISNA()) is slower than IFERROR() but will work on all versions of Excel.

Gord