formula is returning #VALUE! instead of ""

[Sean15]

Hello:

IFERROR(INDEX($E$3:$E$39,MATCH(B50,$B$3:$B$39,0)),"")*-1


This formula above is returning #VALUE ! if value in B50, is not found in range $B$3:$B$39

When I remove *-1, formula is returning "" but I need to have *-1 in formula.

Can someone adjust formula so it returns "" when *-1 is retained in formula.

Thanks for your help.


Regards,

Sean

 

[mrshl9898]

Wouldn't you just do:

IFERROR(INDEX($E$3:$E$39,MATCH(B50,$B$3:$B$39,0))*-1,"")

 

[Osvaldo Palmeiro]

Maybe this:

=IFERROR(INDEX($E$3:$E$39,MATCH(B50,$B$3:$B$39,0))[B][COLOR=#ff0000]*-1[/COLOR][/B],"")

 

[Sean15]

Hi:

Thanks very much.


Sean