software

In sheet1 a1, I have datavalidation list(named range) consisting of sheet
names of my w/book. Some of the names in that list has spaces (example: John
Smith).In some other cell say in d1, I am using formula
d1=indirect(a1amp;quot;!c2quot;).The formula is working with sheet names without spaces
in my list .Its not working with sheet name with spaces like quot;John Smithquot;
sheet. how to get it ?.I can't change/modify names in my list as they are
derived from a named range of other w/book.

Use

=indirect(quot;'quot;amp;a1amp;quot;'!c2quot;).

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;TUNGANA KURMA RAJUquot; gt; wrote in
message ...
gt; In sheet1 a1, I have datavalidation list(named range) consisting of sheet
gt; names of my w/book. Some of the names in that list has spaces (example:
John
gt; Smith).In some other cell say in d1, I am using formula
gt; d1=indirect(a1amp;quot;!c2quot;).The formula is working with sheet names without
spaces
gt; in my list .Its not working with sheet name with spaces like quot;John Smithquot;
gt; sheet. how to get it ?.I can't change/modify names in my list as they are
gt; derived from a named range of other w/book.
Thanks Bob! You are always helpful to me

quot;Bob Phillipsquot; wrote:

gt; Use
gt;
gt; =indirect(quot;'quot;amp;a1amp;quot;'!c2quot;).
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;TUNGANA KURMA RAJUquot; gt; wrote in
gt; message ...
gt; gt; In sheet1 a1, I have datavalidation list(named range) consisting of sheet
gt; gt; names of my w/book. Some of the names in that list has spaces (example:
gt; John
gt; gt; Smith).In some other cell say in d1, I am using formula
gt; gt; d1=indirect(a1amp;quot;!c2quot;).The formula is working with sheet names without
gt; spaces
gt; gt; in my list .Its not working with sheet name with spaces like quot;John Smithquot;
gt; gt; sheet. how to get it ?.I can't change/modify names in my list as they are
gt; gt; derived from a named range of other w/book.
gt;
gt;
gt;

Thank-you, it is my pleasure.

Bob

quot;TUNGANA KURMA RAJUquot; gt; wrote in
message ...
gt; Thanks Bob! You are always helpful to me
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Use
gt; gt;
gt; gt; =indirect(quot;'quot;amp;a1amp;quot;'!c2quot;).
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;TUNGANA KURMA RAJUquot; gt; wrote
in
gt; gt; message ...
gt; gt; gt; In sheet1 a1, I have datavalidation list(named range) consisting of
sheet
gt; gt; gt; names of my w/book. Some of the names in that list has spaces
(example:
gt; gt; John
gt; gt; gt; Smith).In some other cell say in d1, I am using formula
gt; gt; gt; d1=indirect(a1amp;quot;!c2quot;).The formula is working with sheet names without
gt; gt; spaces
gt; gt; gt; in my list .Its not working with sheet name with spaces like quot;John
Smithquot;
gt; gt; gt; sheet. how to get it ?.I can't change/modify names in my list as they
are
gt; gt; gt; derived from a named range of other w/book.
gt; gt;
gt; gt;
gt; gt;