Use of IFERROR to include showing blanks when certain criteria is met

[gruss]

I am using the following forumula to essentially create a summary sheet of data held within another worksheet.

=IFERROR(INDEX(RangeA:RangeA,MATCH(L3,RangeC:RangeC,0),(INDEX(RangeA:RangeA,MATCH(L3,RangeB:RangeB,0))))

It works perfectly for what I need it for however if it picks up a blank field it may show as 0 or 00/01/00 when it is a date. There are also instances when it will show '-'.

Can this formula be amended to show the 0, 00/01/00 and '-' as blank? I have tried every possible scenario but I am completely stuck now. Any help will be appreciated.

[Pete_UK]

I think the 0, 00/01/00 and - are all zero values but the cells have been formatted differently. So, you could do this:

=IF(your_formula=0,"",your_formula)

Hope this helps.

Pete

[gruss]

I think the 0, 00/01/00 and - are all zero values but the cells have been formatted differently. So, you could do this:

=IF(your_formula=0,"",your_formula)

Hope this helps.

Pete

As simple as that! Many thanks for your help.