I'm trying to use two lookup values to return a specific value from a table. I can't for the life of me get it to work..this is my formula can anyone see what i'm doing wrong?
{=INDEX(A8:F21,MATCH(1,(A8:A21=B24)*(A8:F8=B25)))}
I'm trying to use two lookup values to return a specific value from a table. I can't for the life of me get it to work..this is my formula can anyone see what i'm doing wrong?
{=INDEX(A8:F21,MATCH(1,(A8:A21=B24)*(A8:F8=B25)))}
Have you did Ctrl+Shift+Enter after writing the above said formula instead of giving curly parenthesis manually?
If you did this and still have a problem, please upload a sample sheet in order us to check the problem.
I think this is what you are looking for
=IFERROR(INDEX($A$8:$F$21,MATCH($B$24,$A$8:$A$21,0),MATCH($B$25,$A$8:$F$8,0)),"")Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks