Greetings all!
I have the following spreadsheet into which data is transferred from a database.
TestSheet.png
I have a Pay Table that must locate an employee's pay rate in an array (R4C6:R8C11) based on their name and year. The "Year" is updated from a database and so is the employee's name and hours in the Pay Table. I need to fill in R13C3:R19C3 by finding the employee's name in Column 4 and then matching their name in the Rate Lookup Table and bring down the proper rate for a given year. For example, I need to identify the employee's name as "Jim" then find "Jim" in the Rate Lookup Table and locate the appropriate rate by identifying the year ("2") and capturing the value (47.16).
I've tried several combinations of VLOOKUP, INDEX/MATCH, and IF(ISNUMBER(SEARCH))) functions and can't get them to work getting either NAME or VALUE errors.
I'm using the latest Office 365 version of Excel.
Anyone have any hints/strategies for doing this? Thanks in advance!
Bookmarks