| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement with #N/A
Hi,
I need help to write a formula in excel. I want to use vookup to look up a value in another worksheet, if vlookup does not find anything, I want to write "false", otherwise is "false" thanks a lot, Minh |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statement with #N/A
Maybe something along these lines....
=IF(ISNA(YourLookupFormula),"False",YourLookupForm ula) Vaya con Dios, Chuck, CABGx3 "mini" wrote in message ... Hi, I need help to write a formula in excel. I want to use vookup to look up a value in another worksheet, if vlookup does not find anything, I want to write "false", otherwise is "false" thanks a lot, Minh |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statement with #N/A
Thanks a lot, it worked.
"CLR" wrote: Maybe something along these lines.... =IF(ISNA(YourLookupFormula),"False",YourLookupForm ula) Vaya con Dios, Chuck, CABGx3 "mini" wrote in message ... Hi, I need help to write a formula in excel. I want to use vookup to look up a value in another worksheet, if vlookup does not find anything, I want to write "false", otherwise is "false" thanks a lot, Minh |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statement with #N/A
You're quite welcome......thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "mini" wrote in message ... Thanks a lot, it worked. "CLR" wrote: Maybe something along these lines.... =IF(ISNA(YourLookupFormula),"False",YourLookupForm ula) Vaya con Dios, Chuck, CABGx3 "mini" wrote in message ... Hi, I need help to write a formula in excel. I want to use vookup to look up a value in another worksheet, if vlookup does not find anything, I want to write "false", otherwise is "false" thanks a lot, Minh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
Linear Mode
