data validation & multiply values based on the choice

[petelomax]

Hi

ive got a spreadsheet and ive used data validation to look at a list on another tab.

i need to be able to multiply values out based on what i choose on the drop down menu

ive attached a sample spreadsheet to help explain

thanks

[hemesh]

hello try this in c2
=IF($A2="","",VLOOKUP($A2,Sheet2!$A$1:$B$5,2,0)*$B2)
and drag down

[petelomax]

thanks hemesh, works a treat!

[hemesh]

Thanks for the feedback