Originally Posted by
sis92y
Hi there,
Hoping someone can help me out. I need a lookup formula that requires two matching criteria. If a person is receiving Service 1 and is coded as a 2 then the cost is $ per hour. If a person is receiving Service 2 and is coded as a 3 then the cost is $ per hour.
I have it set up as follows:
1 2 3 4
Service 1 $10.01 $13.12 $15.55 $20.29
Service 2 $16.19 $18.21 $21.01 $25.98
Service 3 $33.53 $33.53 $33.53 $33.53
I tried nested IF's but something is not working because it will not give me the correct funding.
Once I have that then I need a formula that calculates only those receiving Service 1 and coded as a 1; Service 2 and coded as a 1; etc.
Thanks in advance.
Bookmarks