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?