I am currently using a HLOOKUP to find a value within a table. But i have to change the Row reference each time for the position i am looking for in the table.
Does someone have a formula that I can insert in Cell L3 to replace my HLOOKUP.
I need to lookup BUCKET (Col H) and ROLE (Col B) and provide corresponding RATE without having to change the Row reference.
Does someone have a formula that I can insert in Cell L3 to replace my HLOOKUP.
I need to lookup BUCKET (Col H) and ROLE (Col B) and provide corresponding RATE without having to change the Row reference.