| 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 |
| 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) | |||
Threaded Mode
