Forum Discussion
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: E F 1 Level Score 2 Level 1: Beginner 1 ...
=INDEX($F$3:$F$7,MATCH(B3,$E$3:$E$7,0))You can try INDEX and MATCH. An alternative could be VLOOKUP.
=INDEX($F$3:$F$7,MATCH(B3,$E$3:$E$7,0))You can try INDEX and MATCH. An alternative could be VLOOKUP.
