Thread: If function to match cols and return value of another col
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default 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")



Reply With QuoteReply With Quote