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

Reply With QuoteReply With Quote