Please see the attachment. I'm trying to return values in Q3 and Q4 based on the data in cells P2:P4. Based on the example Q3 should be 1.836 and Q4 should be .816.
Thanks for your help.
Please see the attachment. I'm trying to return values in Q3 and Q4 based on the data in cells P2:P4. Based on the example Q3 should be 1.836 and Q4 should be .816.
Thanks for your help.
Put this in Q3:
=INDEX(INDEX($D$4:$M$9,MATCH($P$2,$B$4:$B$9,0),0),MATCH(P3,$D$3:$M$3,0))
then copy it into Q4.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks