Help with VLOOKUP and then 2 possible calculations

[Eskonn]

I need help with a calculation

In Row 1 below I have a vlookup that is returning a value in column H. Then multiplying that by Column D.
Here is the formula I have and it works correctly.

=IFERROR(VLOOKUP(D2,'Product Data'!A:F,6,FALSE),"")*G2
for the first line the vlookup value is 80.82 x 5 (D2) = 404.10


A B C D E F G H

Item #	Description	Size	Missing Case QTY	Total Invoiced	Missing Bottle QTY	Total Invoiced Bottles	Total $ Loss
3000	one	1.750 LT	5				404.10
975695	two	750.000 ML			2

But if cell d is blank I would like to then divide the vlookup result in H by column F.

Also if there is a value in both Column D and F I would like to do both calculations and then add them together.

Hope this makes sense
Let me know if any other information is needed

 

[jasonb75]

But if cell d is blank I would like to then divide the vlookup result in H by column F.

If D is blank then the result of the vlookup would be an error so there would be nothing to divide.
In theory, I'm guessing that you will need something like this however your question doesn't make enough sense for me to provide anything more accurate.

=(IFERROR(VLOOKUP(D2,'Product Data'!A:F,6,FALSE),"")*G2)+(IFERROR(VLOOKUP(F2,'Product Data'!A:F,6,FALSE),"")/G2)

 

[Eskonn]

If D is blank then the result of the vlookup would be an error so there would be nothing to divide.
In theory, I'm guessing that you will need something like this however your question doesn't make enough sense for me to provide anything more accurate.

=(IFERROR(VLOOKUP(D2,'Product Data'!A:F,6,FALSE),"")*G2)+(IFERROR(VLOOKUP(F2,'Product Data'!A:F,6,FALSE),"")/G2)

The only reason I I have the if error is so that on rows where I don't have any data yet it just returns it as blank.

In my example I didn't use all of the columns that are on my sheet so the VLOOKUP formula is off
Below in another example with all of the columns

A B C D E F G H I J K

Month	Invoiced Date	Invoice #	Item #	Description	Size	Missing Case QTY	Total Invoiced	Missing Bottle QTY	Total Invoiced Bottles	Total $ Loss
February			3000	one	1.750 LT	5				#DIV/0!

November

975695

two

750.000 ML

2

Your suggestion does work if I have a value in both G and I or in just I.

But if there is just a value in G I am getting the error you can see above in K

 

[jasonb75]

I should have made a couple of other changes to the formula,

=IFERROR(VLOOKUP(D2,'Product Data'!A:F,6,FALSE)*G2,0)+IFERROR(VLOOKUP(F2,'Product Data'!A:F,6,FALSE)/G2,0))

If that is not what you need, please use XL2BB (link at the foot of this reply) to post your data sample, when you copy and paste as you have done it tends to go out of alignment.

 

[Eskonn]

This worked!

Thanks for taking the time to help with this.
Unfortunately I am on a work computer so the XL2BB add in wont install unless I get our corporate IT involved.

Thanks again, I appreciate the help!!