Hi guys. New to the forum. Am trying to make a excel (mac version) worksheet that uses a drop down list(List is made under DataValidation option) and based on the selection, fetch the hourly wage, and display in under the hourly wage heading.
I have 4 pay grades in drop down list - Pay Grade S1, S2, S3 & S4.
I’d like to have excel show hourly wage depending upon selection made. For instance - If s1 is selected, excel would take wage data in a column in my other worksheet with the hourly wage for s1, and so on.
Thanks in advance for your help.
mb
I have 4 pay grades in drop down list - Pay Grade S1, S2, S3 & S4.
I’d like to have excel show hourly wage depending upon selection made. For instance - If s1 is selected, excel would take wage data in a column in my other worksheet with the hourly wage for s1, and so on.
Thanks in advance for your help.
mb