If function to match cols and return value of another col

[Haz]

Hi,

Is it possible to use this function below, to then return the value of the
matching cells in Col I. For example if there is a direct match for A2 in Col
E, then in either this cell of another return the value in col I relating to
Col E?

IF(ISNA(MATCH(A2,E:E,0)),"no match","match")

 

[PCLIVE]

This is untested, but try this:

=IF(ISNA(MATCH(A2,E:E,0)),"no match",INDIRECT("I" & MATCH(A2,E:E,0)))

HTH,
Paul