Glad you've got it sorted.

Bob


"LesLdh" wrote in message
...
I must be thick! I should have spotted that. Thats for the help Bob, that
works great now.

"Bob Phillips" wrote:

Yes it does, in that case, try

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

as both the INDEX and both MATCH functions are using that table


--

HTH

RP
(remove nothere from the email address if mailing direct)


"LesLdh" wrote in message
...
30 in both, does it matter that the table is on a different sheet
named
matrix? I amended your formula to say
=INDEX(matrix!A1:E4,MATCH(H1,A1:A4,0),MATCH(H2,A1: E1,0))


"Bob Phillips" wrote:

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