Drop down value to be selected = this value or less in VBA

Hello everyone,

Today i have a excel with me that i have done previously in my example i wan to let it auto to be selected in my drop down under this or = to the price value

in my example sheet 3 will be where i am taking the value from to auto select the drop down in "B3"

can someone help me with my vba on how can i write that such if the price value is = or less it auto select the correct dropdown ?

Hi i have added however when i type in the value my drop down only appear "Please select designation from this dropdown"

Currently this is what i want with my vba to do
The Total price is = to what the desginator can approve

so if the total price is between 0 - 3000 the director can approve only and of course minister
then if the price is 3000 - 10000 the senior dupty can approve only and of course minister
and so foe till minister anything above 250000 only minister can approve etc

Previously i have try added new vba script but i not sure if this is the correct way to do it

Please Login or Register  to view this content.