Hi!

What is "DIRECT"? Never heard of it. Must be a UDF?

Try this:

=IF(COUNTIF(INDEX(TRCLookup,,1),A14),VLOOKUP(A14,T RCLookup,2,0),VLOOKUP(A14,WO,2,0))

Biff

"Lew" wrote in message
...
I want to make a drop down list from a named range (WO) when the other
conditions of the existing DIRECT statement are not true. The existing
cell
reverence is :"DIRECT(VLOOKUP(A14,TRCLookup,2,0))" I want to add a
condition
that will let me select from the list "WO" if the value in A14 is not in
in
the "TRCLookup" . Any sugestions?