View Single Post
  #15   Report Post  
Ron
 
Posts: n/a
Default

Some of your numbers may in fact be text.
--

Ron P

Sometimes you're the windshield:)
Sometimes you're the bug:(


"LesLdh" wrote in message
...
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))