LinkBack URL
About LinkBacks
I am indexing a series of rows and columns to match 2 criteria. One criteria is in a row. The second is in a column. What I want to return is where they intersect in the table. File attached titled index-match2.
I am indexing a series of rows and columns to match 2 criteria. One criteria is in a row. The second is in a column. What I want to return is where they intersect in the table. File attached titled index-match2.
You INDEX only the table values.
Then you MATCH the row (going down)
Then you MATCH the column (going across).
=INDEX(B2:O21,MATCH(R3,A2:A21,0),MATCH(R2,B1:O1,0))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks