Forum Discussion
giving a drop down list item a value
So I have an excel timesheet which has a drop down list where people can select what kind of work they were doing ( either 'training', 'worker' or 'organiser'). Each of these categories has a different salary value. I've put them in a drop down list but I don't know how to give each one a value - so that in the timesheet, they can say how many hours they did in each category and it will calculate the amount automatically. Can you help please?
https://www.freecodecamp.org/news/excel-vba-tutorial
press Alt+F11
try to modify below codes to change rates.
14 Replies
You can use the VLOOKUP or XLOOKUP function to return the salary associated with the selected type of work.
If you'd like more specific help, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar thanks so much for trying to help. i tried that but it didn't work. I've put a link here to the worksheet:
at the moment the values are incorrect and I want to change them so that the correct amount is calculated in the total column
You need a list with the types of work in the first column and the corresponding salary in the second column. I cannot find such a list in your workbook, not even in the hidden worksheets. Am I missing something?
