Hello! I need help with this file.
I have a tab on here called "Master Pool". On this tab are four columns I need to extract data from. They are Accessibility Hold 1, Accessibility Hold 2, Accessibility Hold 3, and Accessibility Hold 4.
For each row in the sheet, these columns will contain some written out information. This information is separated out, and there are only certain things that will appear in each cell. The information that appears in each cell can be found in the tab "A11Y Tag Placements".
There you'll see headers called "Field 1, Field 2, etc." These headers correspond to the "Accessibility 1, 2, etc." fields in the tab "Master Pool". These are basically the options of what can be written in each cell,
Here's the issue- for a specific cell, these options may not all appear. In most cases only one or two options appear.
What I would like to do is this: I need to search these cells and find specific word strings. For example- I need to search cell X2 in the Master Tab, then I need to see which of the values that could go there are actually there. I need a formula that can search the cell and respond with a whether that specific text is there or not. So in the example, I would like to create a search formula in excel for the word "ASL" in cell X2 that let's me know whether that's there or not.
Solved by T. B. in 11 mins