Help, Index match

[MattExcelLearner]

Good morning all,

I have been trying to get my formula to work as an index match, it works as an vlookup but I'm trying to learn index match more and wondered if anyone can help?

The working vlookup formula is: =IF(VLOOKUP(C4,owssvra!A2:GF27,127,FALSE)=0,"Closed",VLOOKUP(C4,owssvra!A2:GF27,127,FALSE))

I have if equal 0 then show as closed.

I am trying to get this to work in a index match trying different combinations but can't seem to work it.

The index match code: =INDEX(owssvra!$AI:$AI,MATCH(C4,owssvra!$A:$A,FALSE))&""

The index match worked I just want the added formula to work so my 0 show up as closed.

Many thanks and have a great day y'all

Regards