HOw do you specify a text in data validation for cell

[Danny]

For example

I am using this as data validation for a cell

=Indirect(a4)

This returns the contents of the cell which is a named range and the list is
displayed.
But now I want to return the list behind the named range with a name that
has ....say ...
a "L" in front of it.

so it would be:
="L"&Indirect(a4)

but it doesnt work, I get an error.

Any ideas?

Thanks

 

[Debra Dalgleish]

Include the "L" in the Indirect formula:

=INDIRECT("L"&A4)

 

[Guest]

Hi

Try
=INDIRECT("L"&A4)

 

[Danny]

THanks a ton.

That worked for m.e