| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Prevent #N/A values
I'm using the VLOOKUP function and would like the cells that are FALSE to be blank instead of produce the #N/A value. I've read several posts asking similar questions, but I cannot get it to work.... My formula: =IF($C$9="","",VLOOKUP($C$9,'sheet5'!$N$1:$Q$8,2,F ALSE)) I've seen that people say to put 'ISNA', but I must be putting it in the wrong place because I can't get it to work. If someone could please spell it out for me I would greatly appreciate it! As it is right now I am doing paste special and then search and replace....it's a real hassle ;) Thanks for any help you can offer! -- shikamikamoomoo ------------------------------------------------------------------------ shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018 View this thread: http://www.excelforum.com/showthread...hreadid=396288 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| How can I prevent a Chart from showing zero values? | Charts and Charting in Excel | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Threaded Mode
