No, you can include them as well as long as you include the first column in
the first row and vice versa.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Martin Smith" wrote in
message ...
On 2006-05-30 14:23:08 +0100, Martin Smith
said:

On 2006-05-30 13:38:00 +0100, "Bob Phillips"
said:

I think you want INDEX MATCH


=INDEX(full_range,MATCH(row_value,first_column,0), MATCH(Col_value,first_row,
0))

I'll give it a try.

Thanks.

Works a treat once I realised that the first row and column should be
omitted from the full_range