| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup that does not return #N/A
Is there a way to modify the vlookup formula so that it return a blank versus
#N/A. Thank you in advance. |
|
#2
|
|||
|
|||
|
=IF(ISNUMBER(MATCH(A1,B1:B100,0)),VLOOKUP(A1,B1:C1 00,2,0),"")
Regards, Peo Sjoblom "carl" wrote: Is there a way to modify the vlookup formula so that it return a blank versus #N/A. Thank you in advance. |
|
#3
|
|||
|
|||
|
try =if(iserror(vlookup),"",Vlookup)
"carl" wrote: Is there a way to modify the vlookup formula so that it return a blank versus #N/A. Thank you in advance. |
|
#4
|
|||
|
|||
|
On Fri, 10 Jun 2005 12:42:03 -0700, "carl"
wrote: Is there a way to modify the vlookup formula so that it return a blank versus #N/A. Thank you in advance. =IF(ISNA(your_vlookup_formula),"",your_vlookup_for mula) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| Vlookup of an if statement return | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
| VLookup Return Value | Excel Worksheet Functions | |||
Linear Mode
