VLOOKUP for Assiging Vendor Discount to Price

[unclejemima]

Column A: Vendor Name
Column B: Retail Price
Column C: Cost (blank right now)

I have a bunch of different vendors who have different discount levels. I want to use VBLOOUP to Look a the vendor name, then if it finds a match to look at that vendors discount and apply it to the retail price by multiplying Column B with Column E and the cost would come out in column C. The cost would come out in column C, where the VBLOOKUP formula would be pasted.

My Reference sheet looks like this. Its in a separate worksheet called "Configurator"

D1-Apples Inc. E1-0.50
D2-Fruitville Co. E2-0.70
D3-Bananacorp. E3-0.80

So all the prices for vendor Apples Inc. would multiply Retail price x 0.50 to put the cost in Column C

Thanks kindly!

[FDibbins]

to find the discount level, try something like this, copied down...
=VLOOKUP(A1,$D$1:$E$3,2,0)

You can then apply that value to the price

[unclejemima]

Good Idea. I'll give it a go in the morning. Thanks!

[unclejemima]

Solved. Thanks!

[FDibbins]

Happy to help and thanks for the feedback