I'm sure this is a simple problem to solve but I am struggling so thought I would seek help.
Basically I have the following setup:
Team Names in Column A Points scored in Column B
I want to then enter the Team Names in Column C and to then have a formula in Column D which checks the name I've added to Column C against the names in Column A and automatically shows the points scored from Column B.
So as an example - Column A = "Man Utd" Column B = "3" I then type "Man Utd" into Column C and would want "3" (from Column B) to automatically appear in Column D
I guess this is possible but I have tried various VLOOKUP, MATCH, IF (to name a few) formulae with no joy. If anyone can assist it would be appreciated.