Index/Match Returning N/A Result

[Killer17]

Hey All I'm using this formula but it returning a N/A result

=INDEX($A4:$A34,MATCH(MAX(B4:B34),B4:B34,0))

I know the reason is because I have no data in Column B4:B34

Is there away to have the cell blank if there's not data instead of N/A?

Thanks

[JBeaucaire]

Wrap your formula in an IFERROR:

=IFERROR(INDEX($A4:$A34,MATCH(MAX(B4:B34),B4:B34,0)),0)

or

=IFERROR(INDEX($A4:$A34,MATCH(MAX(B4:B34),B4:B34,0)),"")