Using a cell containing a VLookup Formula in a Basic Multiplication Formula

**slampert** · 11-11-2015, 09:11 PM

I have a cell that is using a VLookup formula (using it to pull prices from a price list) and another cell where I input a quantity ordered. In a third cell I am attempting to simply multiply the VLookup cell by the quantity cell however the formula does not work. Please help. In the event it is needed, the vlookup formula I am using is as follows: =IF(ISNA(VLOOKUP(C11,P2:Q209,2,FALSE)),0,VLOOKUP(C11,P2:Q209,2,FALSE))

Thanks!

**Norie** · 11-11-2015, 09:15 PM

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**TMS** · 11-11-2015, 09:18 PM

Define "does not work". In what way? Wrong answer? Error message?

Formula looks OK for a single cell but, if you want to drag it down, you need to make the search table range absolute. And, with Excel 2010, you could use IFERROR instead of IF(ISNA(... and repeating the VLOOKUP.

Regards, TMS

**jason.b75** · 11-11-2015, 09:18 PM

Is it the vlookup formula that doesn't work of the multiplication formula that doesn't work?

How do you define 'doesn't work'? Wrong result? #VALUE! #N/A! something else?

One adjustment you might need to your formula if you're copying it down?

=IF(ISNA(VLOOKUP(C11,P$2:Q$209,2,FALSE)),0,VLOOKUP(C11,P$2:Q$209,2,FALSE))

Without the $ signs the rows will change when you copy the formula down the sheet.