Hi,
Refer to the attached sheet, can you please help us to extract the value using multiple criterias, the values are in different columns.
Regards
Shareez
Hi,
Refer to the attached sheet, can you please help us to extract the value using multiple criterias, the values are in different columns.
Regards
Shareez
Try this...
=INDEX($B$2:$E$6,MATCH(G2,$A$2:$A$6,0),MATCH(G3,$B$1:$E$1,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Enter this formula in G4
=INDEX(B2:E6,MATCH(G2,A2:A6,0),MATCH(G3,B1:E1,0))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
That was quick.
Thank you.
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks