Can anyone help me with an Index Match 3 criteria formula? I tried:
But it gives me the wrong answers. The formula should return whats inthe orange box below.
Please Login or Register to view this content.
I've attached a copy of the sheet.
Can anyone help me?
Pleaseeeee :-(
In c23
=INDEX($C$3:$P$18,MATCH($B23,$A$3:$A$18,0),MATCH(1,INDEX(($C$1:$P$1=C$21)*($C$2:$P$2=C$22),0),0))
Copy down and across
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks