software

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(quot;Grand Totalquot;, INDIRECT(quot;A1:A10quot;), 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.

For info the range (quot;A1:A10quot;) was an example. I have another formula in the
INDRIECT in my sheet which calculates the range I need to look from.

I'm putting this in as a caveat as I'm sure I'll be told I don;t need to use
an INDIRECT if this was as simple as I portray. Just trying to make an
example of a returned range.

TIA.

quot;DaveOquot; wrote:

gt; What I'm trying to do is use a INDIRECT function to return an range array so
gt; a MATCH funtion can look into that range and find a value for me.
gt;
gt; eg.
gt;
gt; MATCH(quot;Grand Totalquot;, INDIRECT(quot;A1:A10quot;), 0)
gt;
gt; This is part of a much larger formula and it's returning an N/A and I can
gt; only assume that it's this part that is wrong as the rest seems to work in
gt; isolation.
gt;
gt; Any ideas that could help at all please guys.
gt;
gt; TIA.

Can you give an example that returns #N/A when it shouldn't, as that works
fine for me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;DaveOquot; gt; wrote in message
...
gt; For info the range (quot;A1:A10quot;) was an example. I have another formula in
the
gt; INDRIECT in my sheet which calculates the range I need to look from.
gt;
gt; I'm putting this in as a caveat as I'm sure I'll be told I don;t need to
use
gt; an INDIRECT if this was as simple as I portray. Just trying to make an
gt; example of a returned range.
gt;
gt; TIA.
gt;
gt; quot;DaveOquot; wrote:
gt;
gt; gt; What I'm trying to do is use a INDIRECT function to return an range
array so
gt; gt; a MATCH funtion can look into that range and find a value for me.
gt; gt;
gt; gt; eg.
gt; gt;
gt; gt; MATCH(quot;Grand Totalquot;, INDIRECT(quot;A1:A10quot;), 0)
gt; gt;
gt; gt; This is part of a much larger formula and it's returning an N/A and I
can
gt; gt; only assume that it's this part that is wrong as the rest seems to work
in
gt; gt; isolation.
gt; gt;
gt; gt; Any ideas that could help at all please guys.
gt; gt;
gt; gt; TIA.
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(quot;Aquot; amp;
MATCH(J1,A$1:A$10000, 0)), 2, 1, 1, 40), 0) 1,1)), quot;dd-mmmquot;)

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

quot;DaveOquot; wrote:

gt; What I'm trying to do is use a INDIRECT function to return an range array so
gt; a MATCH funtion can look into that range and find a value for me.
gt;
gt; eg.
gt;
gt; MATCH(quot;Grand Totalquot;, INDIRECT(quot;A1:A10quot;), 0)
gt;
gt; This is part of a much larger formula and it's returning an N/A and I can
gt; only assume that it's this part that is wrong as the rest seems to work in
gt; isolation.
gt;
gt; Any ideas that could help at all please guys.
gt;
gt; TIA.