View Single Post
  #3   Report Post  
LesLdh
 
Posts: n/a
Default

Thanks Bob, that looked good. Unfortunately I am getting the error #N/A , any
other ideas.


"Bob Phillips" wrote:

Assuming your table is in A1:E4, and the lookup length is in H1, and the
lookup width is in H2, try this

=INDEX(A1:E4,MATCH(H1,A1:A4,0),MATCH(H2,A1:E1,0))