How do I use ISNA on this formula

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)),"",VLOOKUP(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.

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

Thanks.. I got it!

=IF(VLOOKUP(B12,$R$12:$W$2500,3,FALSE)=C12,"Good",(VLOOKUP(B12,$R$12:$W$2500,3,FALSE)-C12))

How about this one.. basically of the vlookup = C12.. then I want it to tell me its Good.. otherwise if the quanitites do not match.. i want the vlookup in one column to subtract from a corresponding cell.. and I want the ISNA in there in case the cell doesn't exist in other set of data. Thanks

- Amar

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad",VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards,
Alan.
"amario" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>

=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" <[email protected]> wrote in
message news:[email protected]...
>
> =IF(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)="Good","Good","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
>