| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
I'm getting an error "N/A" in the cell this formula is located in because
nothing is populated in the first column. How do I "" the error? Thanks. =VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
Look in the help index for ISNA to see the is functions
-- Don Guillett Microsoft MVP Excel SalesAid Software "pm" wrote in message ... I'm getting an error "N/A" in the cell this formula is located in because nothing is populated in the first column. How do I "" the error? Thanks. =VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
Maybe
=IF(ISERROR(VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE )),"",VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE)) Mike "pm" wrote: I'm getting an error "N/A" in the cell this formula is located in because nothing is populated in the first column. How do I "" the error? Thanks. =VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
On Jan 25, 11:29 pm, "Don Guillett" wrote:
Look in the help index for ISNA to see the is functions -- Don Guillett Microsoft MVP Excel SalesAid Software "pm" wrote in message ... I'm getting an error "N/A" in the cell this formula is located in because nothing is populated in the first column. How do I "" the error? Thanks. =VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE) You could try:- =IF(ISNA(VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE)), "",VLOOKUP($A8,Users! A$2:CH$1982,36,FALSE)) This would return a blank cell as the ISNA function returns TRUE if the #NA error is present. If the VLOOKUP returns a value then it will show in the cell as expected. HTH, Matt Richardson, http://teachr.blogspot.com |
| 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
