I am trying to figure out how to explain what I am trying to do.
Say I have a worksheet on the go. I have a two column list like this:
| | E | F |
| 1 | Level | Score |
| 2 | Level 1: Beginner | 1 |
| 3 | Level 2: Intermediate | 2 |
| 4 | Level 3: Novice | 3 |
| 5 | Level 4: Advanced | 4 |
| 6 | Level 5: Expert | 5 |
On a different section of the sheet, I have a 3 column list that looks like this:
| | A | B | C |
| 1 | Name | Level | Score |
| 2 | Adam | Level 3: Novice | |
| 3 | Beth | Level 4: Advanced | |
| 4 | Candace | Level 1: Beginner | |
| 5 | David | Level 2: Intermediate | |
The values in Column B in that second list (Level) are pulled from data entered in another sheet.
What I want to happen is this:
Based on what data is pulled into the cells in Column B, I want Column C to auto-populate with the corresponding score from the list in E1:F6.
For example:
- If cell B3 says "Level 3: Novice", I want the cell next to it, C3, to automatically say "3".
- If the cell in B4 says "Level 4: Advanced", I want C4 to say "4".
Thank you!
