Hi all,
Im looking to find some way of creating a formula that searches the words in column G within column C (red circles in image) and putting the resulting words from column H into the formulated cells in E (blue circle).
G2 = STEPPING so Search C Column for the word STEPPING and then add the result of AAA to E cell.
I want to be able to copy this formula so it auto populates the cells of E column to show the results for its matching search.
Screenshot (1).png
Bookmarks