How to create a formula for a drop down list??

[tommyl18]

Hi I have a spreadsheet for work where I use guys for labour they all have a standard day rates ie, £100 per day, £80 per day etc

I need to somehow link there names on a drop down list to there set day rates without me keep entering it next to there name over and over again. Then add there day rates up and input this into a total box for each guy I have added a photo to try and help you understand what Im after thanks

excel1.jpg

[GarysStudent]

Consider using a small =VLOOKUP() table to retrieve the costs.

[fredlo2010]

Hi Tommy,

You can use like Gary said a small VLOOKUP.

I created a small sample to help you implement some ideas. I have made the ranges dynamics so you will not have to worry about re-sizing them.

Sample.xlsx

Thanks