I am not really sure how to describe this, which is why I am having a hard time writing the formula. I want to match the number in cell T5 with a value in AO7 to AO9 or in cells AQ7 to AQ9.
Then I want to be able to have the value that is selected from AO7 to AO9 or AQ7 to AQ9 put in cell AJ5. Thanks in Advance for your help.
Do you REALLY mean T5??????
=SUMPRODUCT(($AO$7:$AQ$9=T5)*(ISODD(COLUMN($AO$6:$AQ$6)))*$AP$7:$AR$9
copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Sorry about that Glenn. I meant R5. Thanks for solving this riddle for me. I have never heard of ISODD so I will have to study that one. Thanks again for your brilliant help Glenn!
Ysou're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks