AM looking for a formula answer only if possible, pretty sure it would be just my expertise on Excel isn't the best, am learning though !!!
Attached is a spreadsheet that contains a list of Football teams (F) with corrasponding numbers next to them (E).
In column A is a list of footballers and column B has a corrasponding number.
WHat I want to be able to do is type in the footballers names in A and type a number next to them in B, in column C it would read off the corrasponding Team number and populate it with the team name. In the attached example I'll manually list the fist teams in B, i need a formula todo this for me. Probably quite simple.