LinkBack URL
About LinkBacks
Dear Moderator
I Need a help in using the multiple logical formula, please see the attached sample sheet. Appreciate if you could kindly help me in applying the same.
regards
Amul
Dear Moderator
I Need a help in using the multiple logical formula, please see the attached sample sheet. Appreciate if you could kindly help me in applying the same.
regards
Amul
In H7-
=INDEX(C3:E4,MATCH(G7,E3:E4,0),MATCH(E7,C2:E2,0))
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Thank you so much Sourabh...
Much appreciated..
regards
Amul
In H7, try this:
=SUMPRODUCT(($C$3:$D$4)*($C$2:$D$2=E7)*($E$3:$E$4=G7))
thank you..appreciated your efforts...Regards/Amul
Glad we could help. If that solved your question, please mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks