EXCEL Advance Match Function

To check value is avalable
=MATCH(A3,A57:A592,0)

To Get row number of matching value
=MATCH(A3,A57:A592,0)+ROW(A57:A592)-1


Get value of the Cell
=INDIRECT("B"&G5) // B is column and G5 contains row index