Not sure if I understand what you need.

If you're trying to find the result in Column T based on the value in
Column P matching the value in A12 then type this:

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,0)),"",VLOOKU P(A12,$P$12:$U$3323,5,0))

This formula will give you that result but will result in a blank cell
if a match for the value in A12 can not be found in P12:P3323

It's your use of "Good" and "Bad" that I don't understand.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401211