Thread: If value is true the check column for specific values
View Single Post
  #1   Report Post  
MrPetreli MrPetreli is offline
Junior Member
  
Posts: 7
Question If value is true the check column for specific values
Hi

I need a formula to check if a column contains specific values it the column contains a certain value

if column A:A = string "ABC" then check A:A for string "123" & "456". If "456" is missing then display list missing string in cell b2.
Reply With QuoteReply With Quote