help with IF statement

[javelin]

I'm using xl2000 and trying the following IF statement

=IF(LEN(C13)>0,LOOKUP(1,Sheet1!L1313,Sheet1!$L$9:$P$9)," ")

This statement is being executed on Sheet2. If the statement i
evaluated as true, it works just fine. However, if the statement i
evaluated as false I am not getting the blank space I want in the cell
I get #N/A.

Any help would be greatly appreciated!

-jav

 

[Aladin Akyurek]

LOOKUP requires that L1313 is in ascending order.

You might want to try the following 2 cell set up:

In Y1 enter:

=INDEX(Sheet1!$L$9:$P$9,MATCH(C13,$L13:$P13,0))

In X1 enter:

=IF(ISNA(Y1),"",Y1)