Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use ISNA on this formula
=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 |
#2
|
|||
|
|||
=IF(ISNA(VLOOKUP(A12,$P$12:$U$3323,5,FALSE)),"Bad" ,VLOOKUP(A12,$P$12:$U$3323,5,FALSE))
Regards, Alan. "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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=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 |
#5
|
|||
|
|||
Thanks.. I got it! -- amario ------------------------------------------------------------------------ amario's Profile: http://www.excelforum.com/member.php...o&userid=26858 View this thread: http://www.excelforum.com/showthread...hreadid=401211 |
#6
|
|||
|
|||
=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 -- amario ------------------------------------------------------------------------ amario's Profile: http://www.excelforum.com/member.php...o&userid=26858 View this thread: http://www.excelforum.com/showthread...hreadid=401211 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |