Array formula returns zero instead of blank

[cwrivers]

I have this array formula searching a filename for a match of a stars name and if it cant find it its returning a zero instead of blank or error.
{=IFERROR(INDEX(Starlist,MATCH(TRUE,ISNUMBER(SEARCH(Starlist,[@Name])),0)),"")} This formula would be with a space between first and last name

I have the starlist divided into 4 columns for different naming conventions with a " ", "." , "_" (Quotes added for easier reading) or nothing in between first and last name and different search columns and formulas for each like this
{=IFERROR(INDEX(StarlistNS,MATCH(TRUE,ISNUMBER(SEARCH(StarlistNS,[@Name])),0)),"")} This formula would be without anything between first and last name
All the formulas that look in the other columns work just fine, if it cant find a match, it leaves the cell blank. Its just the first one that keeps leaving zeros.

Any ideas why its not working properly?

 

[StephenCrump]

It's a little hard without seeing your layout.

My guess though is that you have a blank cell in Starlist. Your INDEX/MATCH() is returning the value of that cell, which will be zero.

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version.