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