| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
HI,
This is my formula. It works fine. But instead of #N/A if there is not an exact match. I would like to put a text "invalid". How to add the text to this formula. =VLOOKUP(D41,$W$37:$X$47,2,FALSE) Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
One way:
=IF(ISNA(VLOOKUP(...)),"invalid",VLOOKUP(...)) In article , ashley wrote: HI, This is my formula. It works fine. But instead of #N/A if there is not an exact match. I would like to put a text "invalid". How to add the text to this formula. =VLOOKUP(D41,$W$37:$X$47,2,FALSE) Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Try something like this:
=IF(ISNA(VLOOKUP(D41,$W$37:$X$47,2,FALSE)),"Invali d",VLOOKUP(D41,$W$37:$X$47,2,FALSE)) or....maybe this: =IF(COUNTIF(D41,$W$37:$W$47),VLOOKUP(D41,$W$37:$X$ 47,2,FALSE),"Invalid") Does that help? *********** Regards, Ron XL2002, WinXP "ashley" wrote: HI, This is my formula. It works fine. But instead of #N/A if there is not an exact match. I would like to put a text "invalid". How to add the text to this formula. =VLOOKUP(D41,$W$37:$X$47,2,FALSE) Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
If you're using Excel 2007, you can use the function =IFERROR(VLOOKUP([your
vlookup]),"invalid") Else, the other responses will do what you want. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "ashley" wrote: HI, This is my formula. It works fine. But instead of #N/A if there is not an exact match. I would like to put a text "invalid". How to add the text to this formula. =VLOOKUP(D41,$W$37:$X$47,2,FALSE) Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Just be aware that this will mask errors other than #N/A...
In article , Dave F wrote: If you're using Excel 2007, you can use the function =IFERROR(VLOOKUP([your vlookup]),"invalid") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
| 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
