I pasted your formula but it was not accepted by Excel due to 1E10...

It was probably not accepted because the OP's formula uses semicolons as
separators and your regional settings probably use a comma. The separators
are a regional setting.


--
Biff
Microsoft Excel MVP


"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Use it like this
=IF(ISNA(your lookup formula),"",your lookup formula)

ISNA will be true if lookup returns #N/A and you will get blank in your
cell. If it is not #N/A then you get the result of your lookup.

I did not understand what you mean by 1E10... Is it a string? If yes, then
use "1E10".

I pasted your formula but it was not accepted by Excel due to 1E10...

"Walley" wrote:

Hi
I use the fuction LOOKUP(1E+100;C6:C25)-C6, to return a value in G10,
which
work if there is value in C6:C25, but if there is not any value in
C6:C25, it
return the "#N/A", how can I make cell G10 to not show "#N/A", if there
is
not any numbers in C6:C25.
Another question, I use the LOOKUP(1E10;C6:C25)-C6, but it change to
LOOKUP(1E+100;C6:C25)-C6 automatically, why, what the "1E10" mean.
Thank in advance for help