Results 1 to 2 of 2

Thread: Display correct wage based upon pay grade selection in dropdown list

  1. #1

    Display correct wage based upon pay grade selection in dropdown list



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

    Id 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

  2. #2
    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,

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •