lookup function

[cassiopea]

Hi!

I am using LOOKUP Function.
When this function can't find the data, it returns NA(). Now, I want that it returns empty cell (i.e. "") if it can't find the data. I tried with this:

=IF(LOOKUP(O3;$J$2:$J$14;$C$2:$C$14)=NA();"";LOOKUP(O3;$J$2:$J$14;$C$2:$C$14)/1000)

but it still doesn't return EmptyCell but again #NA().

Is there another way to solve this problem?

Thanks in advance