If function to match cols and return value of another col
 

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")

If function to match cols and return value of another col
 

This is untested, but try this:

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

HTH,
Paul

--

"Haz" wrote in message
...
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")