Just for info for others in case they read this post, I got around the issue
by using other functions.

Formula now looks like this...

=TEXT(INDIRECT(ADDRESS(2, MATCH(0,OFFSET(INDIRECT("A" &
MATCH(J1,A$1:A$10000, 0)), 2, 1, 1, 40), 0) + 1,1)), "dd-mmm")

Obviously this is designed for my worksheet and my set-up but if you're
interested it may help you in the future.

"DaveO" wrote:

What I'm trying to do is use a INDIRECT function to return an range array so
a MATCH funtion can look into that range and find a value for me.

eg.

MATCH("Grand Total", INDIRECT("A1:A10"), 0)

This is part of a much larger formula and it's returning an N/A and I can
only assume that it's this part that is wrong as the rest seems to work in
isolation.

Any ideas that could help at all please guys.

TIA.