need help figuring out hourly rate with this indirect lookup

Hi guys,

I have the below formula that works beautifully for me. The user enters a step number into P93 (step being 1 thru 5) and A93 returns a monthly salary rate by looking up on the data tab the job description the user selects in A91. FYI, A89 is the department name.

On the data tab, I have multiple lists of departments and the job titles for each department and each job title has a monthly salary for each of the 5 steps.

But i need it to show the hourly rate. So, the monthly salary needs to be multiplied by 12 and then divided by 2080 and I can't seem to figure out where to put that extra math in the below.

Any help is appreciated, thanks!


=IF(P93="","",INDEX(OFFSET(INDIRECT(A89&"JOBS"),0,P93),MATCH(A91,INDIRECT(A89&"JOBS"),0)))

Well, the part that returns a value starts with INDEX and goes up to the penultimate bracket, so try this:

=IF(P93="","",INDEX(OFFSET(INDIRECT(A89&"JOBS"),0,P93),MATCH(A91,INDIRECT(A89&"JOBS"),0))*12/2080)

Hope this helps.

Pete

That did it. Man, I should have been able to figure that out. I think I've just been staring at it too long

Thanks for your help Pete!