I have a spreadsheet containing named values of football clubs in the leftmost column and named column titles across the top.
How can I insert the value from a certain cell in another sheet?
For example, I want to insert Aston Villa's Ranking of TE in a cell on another worksheet. Is this possible and how can I do it?
Also, If I have a list of the same names i.e Aston Villa on the separate worksheet, can I have drag down to automatically fill the values based on the name of the club in the same worksheet?