Need cell to lookup price then multiply by quantity

I have a worksheet that I used VLOOKUP to find price of item from dropdown. Now the owner wants that cell to also multiply that price by a quantity. Separately I know the formulas, but can't figure out how to combine them. My formulas separately are:

=IF(ISERROR(VLOOKUP(B11,List!P2:Q79,2,FALSE)),"0",(VLOOKUP(B11,List!P2:Q79,2,FALSE)))

=IF(A11="",H11,A11*H11) [this formula doesn't completely work as it errors if no quantity is provided, but I couldn't figure the correction to this either]

My apologies to those shaking your heads at my lack of knowledge, I'm learning as I go.

Thank you for your help,

Good Afternoon, Ali

The worksheet the formulas are used in is a Estimate master that is used to create estimates on an Ipad (casual,in the presence of the customer estimate). It is the same worksheet as in my 1st post (which has been tweaked since then for other requests)

the formula =IF(ISERROR(VLOOKUP(B11,List!P2:Q79,2,FALSE)),"0",(VLOOKUP(B11,List!P2:Q79,2,FALSE))) retrieves the price of the selected HVAC part from a dropdown window. Now the owner wants the option to change the quantity in situations with multi zone homes.

I believe =IF(A11="",H11,A11*H11) is the correct formula to multiply the price, but can not figure out how to make both formulas work on the same cell. At this time I have the second formula off to the side. Please see attached file.



* As to my first post, I did try to reply several times to thank him. Not ever being part of a forum before I thought perhaps replies were not shown and stopped trying in case he had received multiple thank yous. My apologies for the misunderstanding and unintended slight. I will try again to thank him.

The first formula to look up price is in H11, but you will find variations of the same in most of H column. The second formula is in S4, the formula in R4 is just trash.

If you choose a part from a dropdown box under the header of Furnace, it will show the part price in H11. If you add a quantity in A11, the correct price is showing in S4, with the second formula. My question is how to have cell H11 not only lookup the price, but multiply it by the quantity in A11.

Thank you

Hi

Try this but first remove data validation in H11

Formula:

Please Login or Register  to view this content.

or better if you use Excel 2016

Formula:

Please Login or Register  to view this content.

Note: SUM is to do a SUM not to multiply
=SUM(D51*F51) is not good.
Use
=D51*F51
or better
=IFERROR(D51*F51;"")

Hi Jose,

Thank you so much, that worked perfectly.

I appreciate it,

Michele

You are welcome.

Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.