# need help figuring out hourly rate with this indirect lookup

1. ## 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)))

2. ## Re: need help figuring out hourly rate with this indirect lookup

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

3. ## Re: need help figuring out hourly rate with this indirect lookup

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

4. ## Re: need help figuring out hourly rate with this indirect lookup

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1