VLOOKUP advice

[robert_harper]

I hope I have typed it correctly according to the rules. I wanted to know how exactly this code understands to minus the percentage in C33.

I love the idea of it being able to search for a word from a group and adjusting the values.

Please Login or Register  to view this content.

With this type of formula I could take a trade price and make it estimate a price according to what kind of product it is, correct?
Food - 50%
Treats - 80%
etc

[NBVC]

I wanted to know how exactly this code understands to minus the percentage in C33.

It's not actually subtracting, it's multiplying your price by the percentage to give a fractional amount....

[robert_harper]

Also with the formula

£10 5% discount calculates £0.50

I would rather it work out the 5% discounts

£10 5% discount calculates £9.50


Any ideas?

[robert_harper]

I see so it is the old divide the numerator by the denominator etc

cheers, just get my head around switching it around

[NBVC]

Will this not do it?

=F2-VLOOKUP(A2,$B$33:$D$36,3,FALSE)*$F2

Where F2 is the Price and the result is the discounted price... (ie. original price - discount).

[robert_harper]

Nice one! lol just runs off your hands lol


One thing though, why doesn't it allow me to adjust the box I tried to select the

[code] =F2-VLOOKUP(A2,$B$33:$C$36,3,FALSE)*$F2 [code]

[NBVC]

Not sure what you mean by "adjust the box"?

[robert_harper]

Sorry wasn't very clear. I removed one of the discounts in the selection so there was only one discount to be applied.

[NBVC]

Still unsure what you are trying to say....

Do you want to replace the F2 with an actual value?

Please elaborate.

[robert_harper]

\1
\1

Just want to change the selection, please check out the screen prints

[NBVC]

It looks to me that you might just want to change the column index to 2

e.g

=F2-VLOOKUP(A2,$B$33:$C$36,2,FALSE)*$F2

Is that what you're meaning?

[robert_harper]

ah makes sense! Yes I think so

Cheers mate!