Removing The N/A from showing in open fields
 

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

Im 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!

Removing The N/A from showing in open fields
 

One way:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Killer" wrote in message
...
=LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)

Im 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!

Removing The N/A from showing in open fields
 

Perhaps this might be more to your liking:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
One way:

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

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Killer" wrote in message
...
=LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)

Im 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!

Removing The N/A from showing in open fields
 

http://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: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=535358

Removing The N/A from showing in open fields
 

Thanks Ragdyer much appreciated.

"Ragdyer" wrote:

One way:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Killer" wrote in message
...
=LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)

Im 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!

Removing The N/A from showing in open fields
 

Two options:

1]

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

2] Add a record in C7:D7 consisting of 0 and ="" on Index without
disturbing the ascending order that is applied to C8:D60.

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:
=LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)

Im 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!