This is driving me mad, I used to know the formula, but it has now completely escaped me. Basically I want to be able to input an entry in Column D and have column E automatically pull the corresponding entry from column A. For example, if I enter "Celtic" into F3, then I want E3 to pull through with "Green". And if I put "Leeds" into F4, then I would like E4 to pull through "white". Eventually I would like Columns D and E to be on a separate worksheet and for the info to be pulled of a hidden page.


1 A B D E
2 Team Shirt Colour Team Shirt Colour
3 Liverpool Red
4 Chelsea Blue
5 Leeds White
6 Norwich Yellow
7 Celtic Green

Any help would be gratefully received, I am sure someone out there has this at their fingertips!