excell if cell contains and ID then show text code example
Example: excel if cell contains
"A" "B" "C"
"1" Frog and duck duck =ISNUMBER(SEARCH(B2,A2))
"C1" shows TRUE ('duck' is located at position 10 in "A1")
"A" "B" "C"
"1" Frog and duck duck =ISNUMBER(SEARCH(B2,A2))
"C1" shows TRUE ('duck' is located at position 10 in "A1")