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

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

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

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