Introducing a % into a Vlookup formula

[brian.baker13]

Hi

I am doing work in Cost of Overfill in Manufacturing

=-(N5-((VLOOKUP(B5,'CoO DATA TABLE'!$C$5:$H$999,4,0))))*M5/1000))
The following formula takes an actual average weight of product from
manufacturing (N5) and subtracts the standard weight for a product,
this is in the lookup reference above (4). It then multiplies this
quantity i.e.

220g-200g * by the manufactured quantity (M5)

What I want the formula to do is multiply the manufactured quantity by
the %age difference between N5 and the reference in the lookup table.

The reason I am wanting the change is because the current reference is
applicable to the number of units made in manufacturing and now I have
to apply this formula to a system where we are working in kilos rather
than units produced.

Much Appreciated

Brian

 

[Bob Phillips]

Do you mean

=-N5/(N5-VLOOKUP(B5,'CoO DATA TABLE'!$C$5:$H$999,4,0))*M5/1000


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[brian.baker13]

Do you mean

=-N5/(N5-VLOOKUP(B5,'CoO DATA TABLE'!$C$5:$H$999,4,0))*M5/1000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)













- Show quoted text -

Thanks Bob did not work

 

[Bob Phillips]

In what way? Was it close?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[brian.baker13]

In what way? Was it close?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)







- Show quoted text -

Hi Bob

Had a think about it which was spurned from your assistance and came
up with this that worked

=IF(OR(B5="",B5<=0),"",IF(OR(N5="",N5=0),"",-(N5-VLOOKUP(B5,'CoO DATA
TABLE'!$C$5:$H$999,5,0))/VLOOKUP(B5,'CoO DATA TABLE'!$C$5:$H
$999,5,0)*M5))

Cheers

Brian