Recollect I offered you this well illustrated response earlier, based on
*your* sample, which unfortunately you seem to ignore
------------------------------------------------------
Another option to return the intersection value within the table
is to use a normal index/match on top row/leftmost col
Illustrated in new sheet: x in your sample:
http://www.freefilehosting.net/download/3efdj
Index_match top row_left col.xls
In sheet: x,
Assume Size & Length values are selected from DVs / input in P2:Q2 down
In R2:
=IF(COUNTA(P2:Q2)<2,"",INDEX($B$3:$N$7,MATCH(P2,$A $3:$A$7,0),MATCH(Q2,$B$2:$N$2,0)))
Copy down to return results from the table
--------------------
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---