software

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 quot;falsequot;, otherwise is quot;falsequot;
thanks a lot,
Minh

Maybe something along these lines....

=IF(ISNA(YourLookupFormula),quot;Falsequot;,YourLookupForm ula)

Vaya con Dios,
Chuck, CABGx3quot;miniquot; gt; wrote in message
...
gt; Hi,
gt; I need help to write a formula in excel. I want to use vookup to look up
a
gt; value in another worksheet, if vlookup does not find anything, I want to
gt; write quot;falsequot;, otherwise is quot;falsequot;
gt; thanks a lot,
gt; Minh
Thanks a lot, it worked.quot;CLRquot; wrote:

gt; Maybe something along these lines....
gt;
gt; =IF(ISNA(YourLookupFormula),quot;Falsequot;,YourLookupForm ula)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;miniquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I need help to write a formula in excel. I want to use vookup to look up
gt; a
gt; gt; value in another worksheet, if vlookup does not find anything, I want to
gt; gt; write quot;falsequot;, otherwise is quot;falsequot;
gt; gt; thanks a lot,
gt; gt; Minh
gt;
gt;
gt;

You're quite welcome......thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3quot;miniquot; gt; wrote in message
...
gt; Thanks a lot, it worked.
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Maybe something along these lines....
gt; gt;
gt; gt; =IF(ISNA(YourLookupFormula),quot;Falsequot;,YourLookupForm ula)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;miniquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi,
gt; gt; gt; I need help to write a formula in excel. I want to use vookup to look
up
gt; gt; a
gt; gt; gt; value in another worksheet, if vlookup does not find anything, I want
to
gt; gt; gt; write quot;falsequot;, otherwise is quot;falsequot;
gt; gt; gt; thanks a lot,
gt; gt; gt; Minh
gt; gt;
gt; gt;
gt; gt;