Hi Frank,

Am Sun, 10 Jan 2016 11:26:39 -0500 schrieb Phrank:

=Vlookup($D2,NamedRange,4,False)="Need"
(where D2 is on Sheet1, 'NamedRange' is on Sheet2 and is 4 columns
wide and 'Need' may be in the 4th column)

look into the other group. There is an answer.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional