Biff is correct, he did help me before.

I tried his response but it disd not do what I need it to do. Let me
restate the problem to clarify (or muddy) the air.

In cell A14 I have a Data Validation list that is controled by the
statement:=JobDescription. Job Description is a named range with a
blank row included in the list so that the user may enter a value if
the values that are named in the list are not what the user needs.
Cell B14 is another Data Validation list with the following formula:
=INDIRECT(VLOOKUP(A14,TRCLookup,2,0)).

What I want to add to B14 is a way to have the named Range "FOTRC" to
be used instead of "TRCLookup" if the blank row is chosen in cell a14.

Hope this makes sense.


--
LewR
------------------------------------------------------------------------
LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420
View this thread: http://www.excelforum.com/showthread...hreadid=525102