Forum Discussion
giving a drop down list item a value
https://www.freecodecamp.org/news/excel-vba-tutorial
press Alt+F11
try to modify below codes to change rates.
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:
https://letyoungpeopletalk-my.sharepoint.com/:x:/g/personal/niki_powers_lets-talk_scot/EU4XRZM54QpNl6ihEKECAw8BO6CWebzxJAyPprNbzu8M9A?e=mrbwkW
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?
- Hi Again,
I've set up a new worksheet but still can't fix it - how do i make the two lists that you have suggested?
