Mar 21 2022 10:35 PM
I am building an excel spreadsheet for staff wages. I use a drop down list that describes the shift done, or as the case maybe, a day off. However the pay rates and associated penalty rates differ depending on the shift done. Is there a formula or function that can recognise a drop down description from my list and apply then apply relevant pay rate. Thank you
Mar 22 2022 01:36 AM
@Mike_Geraghty You would have to create one or more lookup tables first and then use eg. VLOOKUP or INDEX and MATCH to find the appropriate rate for the chosen shift. Google for "VLOOKUP Excel" and you will find many examples and tutorials on-line. From the screenshot I conclude you're using an older version of Excel, so you will not be able to use XLOOKUP, a new functions that is often recommended nowadays.
Mar 22 2022 05:56 PM