Formula returning 0 if nothing found in Index/Match

[ExcelRoy]

Hi,

the following formula works great until there is noting found in the index/match

=IFERROR(INDEX('Details'!$C$2:$C$10000,MATCH(E10,'Details'!$B$2:$B$10000,0),0),"")

Is there a way to show"-" instead of the "0" returned

Many thanks

 

[dreid1011]

Of course. One way:

=IF(your formula here=0,"-",your formula here)

 

[ExcelRoy]

Hi dreid1011,

of course many thanks got it now

 

[dreid1011]

You're welcome.