Forum Discussion

Sara_Boom's avatar
Sara_Boom
Copper Contributor
Mar 20, 2023
Solved

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:

 EF
1LevelScore
2Level 1: Beginner1
3Level 2: Intermediate2
4Level 3: Novice

3

5Level 4: Advanced

4

6Level 5: Expert

5

 

On a different section of the sheet, I have a 3 column list that looks like this:

 ABC
1NameLevelScore
2AdamLevel 3: Novice 
3BethLevel 4: Advanced 
4CandaceLevel 1: Beginner 
5DavidLevel 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!

Resources