Cell intersection lookup in excel
Hi friends,
I need to have a two dimensional search here i can populate a cell which contains data and another one same contents at it's intersection of a row and column each of which will be having some values to it. In shot i need to have combination of HLOOKUP and MATCH functions should do it. I have asked my friends about the same they told me that it's possible but don't know the way can anyone help me out and i want this thing to be done in Excel 2007
Intersection Lookup in Excel 2007
In this case i would recommend you to use the following formula for two matches to feed to the index function:
Code:
=INDEX(A2:G22,MATCH(J3,A2:A22),MATCH(I3,A2:G1,0))
where I3 is the size and J3 is the rating
Cell intersection lookup in excel
If you are not able to understand anything then i would suggest you to have a look at match function in help section which will give you an idea of how to use it in that you will require a third parameter , Match_type, to the MATCH function and set this parameter to 0 (zero) as your data in the $A$2:$A$13 range is not sorted.