=IF(isna(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"BAD" ,VLOOKUP(A12,$P$12:$U$3323
,5,FALSE))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"amario" wrote in
message ...

=IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Goo d","BAD")


How can I get the ISNA in there.. while maintaining my IF output. I'd
like the box to tell me if there was a match.. if not.. then tell me
its bad.. while blanking out the #n/A as i'm comparing 2 sets of data
against each other. Thanks!

- Amar


--
amario
------------------------------------------------------------------------
amario's Profile:
http://www.excelforum.com/member.php...o&userid=26858
View this thread: http://www.excelforum.com/showthread...hreadid=401211