software

=LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)

I’m using this code on my excel sheet and when Column I6 is blank it shows
N/A in column M6 how can this be removed not to show the N/A

Thanks ahead!One way:

=IF(ISNA(MATCH(I6,index!$C$8:$C$60,0)),quot;quot;,LOOKUP(I 6,index!$C$8:$D$60))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Killerquot; gt; wrote in message
...
gt; =LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)
gt;
gt; I’m using this code on my excel sheet and when Column I6 is blank it shows
gt; N/A in column M6 how can this be removed not to show the N/A
gt;
gt; Thanks ahead!
gt;Perhaps this might be more to your liking:

=IF(ISNA(LOOKUP(I6,index!$C$8:$D$60)),quot;quot;,LOOKUP(I6 ,index!$C$8:$D$60))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Ragdyerquot; gt; wrote in message
...
gt; One way:
gt;
gt; =IF(ISNA(MATCH(I6,index!$C$8:$C$60,0)),quot;quot;,LOOKUP(I 6,index!$C$8:$D$60))
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt;
gt; --------------------------------------------------------------------------
-
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; --------------------------------------------------------------------------
-
gt; quot;Killerquot; gt; wrote in message
gt; ...
gt; gt; =LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)
gt; gt;
gt; gt; I’m using this code on my excel sheet and when Column I6 is blank it
shows
gt; gt; N/A in column M6 how can this be removed not to show the N/A
gt; gt;
gt; gt; Thanks ahead!
gt; gt;
gt;
www.techonthenet.com/excel/formulas/iserror.php

You may want to try the iserror function with your formula, the above
site has a good example--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=535358Thanks Ragdyer much appreciated.

quot;Ragdyerquot; wrote:

gt; One way:
gt;
gt; =IF(ISNA(MATCH(I6,index!$C$8:$C$60,0)),quot;quot;,LOOKUP(I 6,index!$C$8:$D$60))
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt; quot;Killerquot; gt; wrote in message
gt; ...
gt; gt; =LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)
gt; gt;
gt; gt; I’m using this code on my excel sheet and when Column I6 is blank it shows
gt; gt; N/A in column M6 how can this be removed not to show the N/A
gt; gt;
gt; gt; Thanks ahead!
gt; gt;
gt;
gt;

Two options:

1]

=IF(I6lt;gt;quot;quot;,LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$ D$60),quot;quot;)

2] Add a record in C77 consisting of 0 and =quot;quot; on Index without
disturbing the ascending order that is applied to C860.

This allows you to invoke:

=LOOKUP(I6,Index!$C$7:$C$60,Index!$D$7:$D$60)

allowing to avoid #N/A for a lookup ref that is empty.

Killer wrote:
gt; =LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)
gt;
gt; I’m using this code on my excel sheet and when Column I6 is blank it shows
gt; N/A in column M6 how can this be removed not to show the N/A
gt;
gt; Thanks ahead!
gt;