Apr 30 2021 06:40 AM
Use a structured reference to look up the value in the post secondary years column. Retrieve the value in the second row of the table in the range P13:U14 using absolute reference . Because base hourly rate is tiered based on the number of years of education, find approximate match.
Apr 30 2021 06:55 AM
Hi,
It's not a good idea to do an horizontal lookup for a vertical table.
I don't know what exactly you pretend with the lookup, but I guess you want to count. I did it with a VLOOKUP and a COUNTIF.
Kind regards
Hans
Apr 30 2021 08:31 AM