I used your data in my test, and it worked fine. What values do you have in
H1 and H2?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"LesLdh" wrote in message
...
Yes, the lookup values do exist in the row/column headings.
"Bob Phillips" wrote:
Do all of your lookup values exist in the row/column headings? If not,
what
would you expect to get?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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))
|