Forum Discussion
Sara_Boom
Mar 20, 2023Copper Contributor
If a cell's contents match the contents of another cell, return the value of the cell beside it.
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!
=INDEX($F$3:$F$7,MATCH(B3,$E$3:$E$7,0))
You can try INDEX and MATCH. An alternative could be VLOOKUP.
2 Replies
- OliverScheurichGold Contributor
=INDEX($F$3:$F$7,MATCH(B3,$E$3:$E$7,0))
You can try INDEX and MATCH. An alternative could be VLOOKUP.
- Sara_BoomCopper Contributor