Vlookup formula problem!!!

You would be better off using a userform.

They give you a lot more control.

However I will try to understand your requirement.

Not easy. using your solution.

My first comment is why are you using a drop down list to select an employee name? That is so crude for more than 8 names.

You should instead use two cells, one for first name, one for second name.

Typing M in first name box will fill a listbox with all employees whose first name starts with M
Typing T in the surname box will remove all employees whose surname doesn't start with T

the more letters you type in each box the narrower your selection will get.

Thank you very much for constrictive criticism :-) lol
Yes I would like to try your solution please.
Thanks Again
Dan

I would go for any solution that works :-)
All I need is a Managers to fill in the form with names and select the type of Replacement which will calculate cost base on the rates in "Data" So when they choose that replacement isn't required then it would not return any value but if they select for example attending on a day off it will return daily rate, if they choose to be replaced by one of the Agency ops it will change the value base on selection.

Thhhhhank You