Hi again,

Here are a couple things that I've already tried that haven't worked:

I first tried this:

=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)

I also tried this:

=INDEX(Sheet1!$D:$D, MATCH($D$2,Sheet2!$A:$A))="NEED"
(although, I realize the Match doesn't include Column D where the
'Need' value would be)

And I tried this too:

=VLOOKUP(D2,EventDescription,MATCH("Need",$D$D,0), FALSE)

I believe there is some combination of Vlookup, or Index/Match that
will do this, but I've just not been able to make the combination. I'd
appreciate any help with this. Thanks!