I am trying to search a column with a lot of text in it for a few different text strings, and if found, I would like to display a value that corresponds to that string
Status:
Rag: Red, because….
Rag:Green, moving along
Rag: Green On track
RAG: Not Started
I would like to search the above column for the string listed below on a different sheet, and display in a column on the first sheet, the value in column B
COLUMN A COLUMN B
RAG: Green G
RAG: Red R
RAG: Amber A
RAG:Green G
RAG:Red R
RAG:Amber A
RAG: RED/AMBER/GREEN NS
RAG:Not Started NS
RAG: NOT STARTED NS
RAG: Not Started NS
So the result would be
Rag: Red, because…. R
Rag:Green, moving along G
Rag: Green On track G
RAG: Not Started NS
Bookmarks