Display correct wage based upon pay grade selection in dropdown list

mb1957

New member
Joined
Jul 29, 2014
Messages
1
Reaction score
0
Points
0
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
 
Good afternoon,

I think you could an index-match or vlookup.

=VLOOKUP ( -- Drop Down Box -- , -- Wage Data Range (Classification must be on the far left) --, # of columns from left to answer, FALSE )

=INDEX ( -- Wage Value Column -- , MATCH ( -- Drop Down Box --, -- Classification Column -- , 0 ))

Hope this helps,
 
Back
Top