Change #NAME? to blank

[Fazila]

is there any way this can be done? The formula I am using is:

{=IFERROR(INDEX(Teachers,SMALL(IF(subs=$B$3,ROW(Teachers)),ROW(4:4))-1,1),””)}

Thanks

 

[steve the fish]

You need to use "" not ””

 

[Aladin Akyurek]

Try rather...

{=IFERROR(INDEX(Teachers,SMALL(IF(subs=$B$3,ROW(Teachers)-ROW(INDEX(Teachers,1,1))+1),ROWS($1:1))),"")}

provided that Teachers and subs exist and correctly defined.

 

[Fazila]

You need to use "" not ””

Sorry Steve not sure what you meant but thanks for posting anyway

 

[steve the fish]

I mean you need to use the correct inverted commas "". Yours were slanted hence excel giving the name error. Ill presume you copied that formula from a webpage? The slanted inverted commas are not correct but often are used in webpages.