| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I have a false Vlookup give a blank instead of #N/A?
I'm looking up values in a column using the VLOOKUP with the FALSE included
so that if the lookup item isn't present, I purposely get a "#N/A". Can I nest an "IF" statement so that if the vlookup returns a "#N/A", I want it to appear blank instead of getting the "#N/A"? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I have a false Vlookup give a blank instead of #N/A?
=IF(ISNA(vlookup_formula),"",vlookup_formula)
-- Regards, Peo Sjoblom "TQCON" wrote in message ... I'm looking up values in a column using the VLOOKUP with the FALSE included so that if the lookup item isn't present, I purposely get a "#N/A". Can I nest an "IF" statement so that if the vlookup returns a "#N/A", I want it to appear blank instead of getting the "#N/A"? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I have a false Vlookup give a blank instead of #N/A?
Thanks, Peo. That solves the problem. I also then noticed that this
question is a common one that has been solved many times. "Peo Sjoblom" wrote: =IF(ISNA(vlookup_formula),"",vlookup_formula) -- Regards, Peo Sjoblom "TQCON" wrote in message ... I'm looking up values in a column using the VLOOKUP with the FALSE included so that if the lookup item isn't present, I purposely get a "#N/A". Can I nest an "IF" statement so that if the vlookup returns a "#N/A", I want it to appear blank instead of getting the "#N/A"? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to give value of a BLANK cell based on another | Excel Worksheet Functions | |||
| $C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # | Excel Worksheet Functions | |||
| Array formula to give blank | Excel Worksheet Functions | |||
| IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
| Can I add blank space instead of 'FALSE' in VLookup? | Excel Worksheet Functions | |||
Hybrid Mode
