Thread: Index Function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Index Function

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
---