Find text in multiple cells and return different text
ClosedMLloyd81 Posts 4 Registration date Saturday September 17, 2022 Status Member Last seen September 18, 2022 - Sep 18, 2022 at 11:50 AM
- Find text in multiple cells and return different text
- Conditional formatting if cell contains text - Excel Forum
- Allow multiple downloads chrome - Guide
- If cell contains date then return value ✓ - Excel Forum
- How to make multiple selections in photoshop - Guide
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
4 responses
Sep 18, 2022 at 09:57 AM
MLloyd81, Good morning.
Dear teacher, maybe I'm missing something in your explanation.
Wouldn't the MATCH function be useful to you in this case?
A little image of the spreadsheet would already help me understand your layout and what you want as a result.
Hope it helps.
Sep 18, 2022 at 10:27 AM
Thank you for your reply. I am a novice on Excel and only know a few formula and Google helps with the rest.
I have used the EXACT formula but it only works for one cell.
I have a number of sheets, all with a similar format and I wanted a snapshot sheet so I could see the level of each child in each area at a glance. Any help would be appreciated.
thank you
Sep 18, 2022 at 10:43 AM
Welcome Teacher.
Don't worry,
All of us, at one time or another, were also beginners in some subject.
Could you please, show us a view of your spreadsheet and what a desired answer would look like for you?
Sep 18, 2022 at 11:38 AM
So the top sheet is the analysis sheet with all of the names of each section at the top with the list of children down the rows at the side. The bottom picture is an example of each sheet and the assessment, it consists of a range of statements in each level moving from Bronze up to Outcome 6 and there is a column for each child in the class across the top. Each sheet is a similar format. You can select from the drop down in each box to say whether the child is emerging, developing or secure in this skill level. This assessment is done at the start of the year. What I want to happen is that in the analysis sheet, the child will show the level (Bronze to Outcome 6) in the cell for each column related to the skill. So whichever cell says secure in the individual sheets the corresponding level will appear in the analysis sheet under that section and this will be different for each child.
Technically I want to search the cells for the child and find the box that says secure, then the corresponding level will appear in the analysis sheet. So if D4 is secure Gold will show. I hope that makes sense.
Sep 18, 2022 at 11:50 AM