Removing The N/A from showing in open fields

[Killer]

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

 

[Ragdyer]

One way:

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

 

[Ragdyer]

Perhaps this might be more to your liking:

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

 

[davesexcel]

http://www.techonthenet.com/excel/formulas/iserror.php

You may want to try the iserror function with your formula, the abov
site has a good exampl

 

[Killer]

Thanks Ragdyer much appreciated.

One way:

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

 

[Aladin Akyurek]

Two options:

1]

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

2] Add a record in C77 consisting of 0 and ="" 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.