PDA

View Full Version : How to create a formula for a drop down list??



tommyl18
12-28-2013, 05:32 AM
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

11008

GarysStudent
12-28-2013, 07:31 AM
Consider using a small =VLOOKUP() table to retrieve the costs.

fredlo2010
12-28-2013, 05:20 PM
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.

11010

Thanks