| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
i trying to use this forumla:
=VLOOKUP if unable to find out the values, can the data cells auto set to blank? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
You can't make the cells empty, but you can make them look blank.
=if(isna(vlookup(...)),"",vlookup(...)) or in xl2007 =iferror(vlookup(...),"") kyoshirou wrote: i trying to use this forumla: =VLOOKUP if unable to find out the values, can the data cells auto set to blank? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
currently if i search a valid data, it will shows the result.
But if i search again with an invalid data, the cells cant reflect blank or look blank. "Dave Peterson" wrote: You can't make the cells empty, but you can make them look blank. =if(isna(vlookup(...)),"",vlookup(...)) or in xl2007 =iferror(vlookup(...),"") kyoshirou wrote: i trying to use this forumla: =VLOOKUP if unable to find out the values, can the data cells auto set to blank? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
I don't understand the comment.
kyoshirou wrote: currently if i search a valid data, it will shows the result. But if i search again with an invalid data, the cells cant reflect blank or look blank. "Dave Peterson" wrote: You can't make the cells empty, but you can make them look blank. =if(isna(vlookup(...)),"",vlookup(...)) or in xl2007 =iferror(vlookup(...),"") kyoshirou wrote: i trying to use this forumla: =VLOOKUP if unable to find out the values, can the data cells auto set to blank? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
i mean when i have this:
MsgBox "Invalid Data Entered" it will gives user a error msg when invalid search is entered. Can that MsgBox "Invalid Data Entered" be used inside VLOOKUP togther? Coz right now, i do no use any "Search" button to activate the code. "Dave Peterson" wrote: I don't understand the comment. kyoshirou wrote: currently if i search a valid data, it will shows the result. But if i search again with an invalid data, the cells cant reflect blank or look blank. "Dave Peterson" wrote: You can't make the cells empty, but you can make them look blank. =if(isna(vlookup(...)),"",vlookup(...)) or in xl2007 =iferror(vlookup(...),"") kyoshirou wrote: i trying to use this forumla: =VLOOKUP if unable to find out the values, can the data cells auto set to blank? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
Maybe:
=if(isna(vlookup(...)),"Invalid data entered",vlookup(...)) Is this for a macro/VBA or a formula in a worksheet? kyoshirou wrote: i mean when i have this: MsgBox "Invalid Data Entered" it will gives user a error msg when invalid search is entered. Can that MsgBox "Invalid Data Entered" be used inside VLOOKUP togther? Coz right now, i do no use any "Search" button to activate the code. "Dave Peterson" wrote: I don't understand the comment. kyoshirou wrote: currently if i search a valid data, it will shows the result. But if i search again with an invalid data, the cells cant reflect blank or look blank. "Dave Peterson" wrote: You can't make the cells empty, but you can make them look blank. =if(isna(vlookup(...)),"",vlookup(...)) or in xl2007 =iferror(vlookup(...),"") kyoshirou wrote: i trying to use this forumla: =VLOOKUP if unable to find out the values, can the data cells auto set to blank? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| 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 | |||
Hybrid Mode
