| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
Check to see if the vlookup shows up as an error... so it would look like this
=If(Iserror(Vlookup()),"",Vlookup()) "HJ" wrote: is there a way for a vlookup formula to return a blank cell if it is unable to find a match in the list? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
=if(isna(vlookup(...)),"",if(vlookup(...)="","",vl ookup(...))))
or =if(iserror(1/len(vlookup(...)),"",vlookup(...)) And xl2007 has added an =iferror(), too. HJ wrote: is there a way for a vlookup formula to return a blank cell if it is unable to find a match in the list? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
It's not showing up as an error, it is pulling the wrong information. ?
"akphidelt" wrote: Check to see if the vlookup shows up as an error... so it would look like this =If(Iserror(Vlookup()),"",Vlookup()) "HJ" wrote: is there a way for a vlookup formula to return a blank cell if it is unable to find a match in the list? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
Hi,
If your VLOOKUP is returning the wrong information, you've probably omitted the 4th argument. If you don't put in the 4th argument as ,FALSE then if VLOOKUP doesn't find what you've asked for, it just goes for the closest match. If you do put in the ,FALSE then if VLOOKUP can't find what you've asked for, it will return an error, which you can use as described in the other replies. Regards - Dave. "HJ" wrote: It's not showing up as an error, it is pulling the wrong information. ? "akphidelt" wrote: Check to see if the vlookup shows up as an error... so it would look like this =If(Iserror(Vlookup()),"",Vlookup()) "HJ" wrote: is there a way for a vlookup formula to return a blank cell if it is unable to find a match in the list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
