INDEX AND MATCHING FUNCTIONS
Your welcome and thanks for the feedback
"Jeanette" wrote:
Mike: thanks very much it worked beautifully!
--
Thanks, Jeanette
"Mike H" wrote:
Jeanette,
Try this
=INDEX(A1:D5, MATCH(99,A1:A5,0), MATCH(0.9,A1:D1,0))
in practice I'd use cell references for the lookup values
Mike
"Jeanette" wrote:
Hi hoping someone can help. I've read through various posts and I am still a
bit confused. I want to return the value of a PIR of 98 and an IPF of 0.8
(6.6%)
IPF
0.7 0.8 0.9
PIR 100 6.00% 7.00% 8.00%
99 6.20% 6.80% 7.80%
98 5.80% 6.60% 7.60%
97 5.60% 6.40% 7.40%
--
Thanks, Jeanette
|