You chaps have been really helpful so far and I'm hoping you can help with my latest problem.

I'm constructing a football league spreadsheet. I have my fixtures/results on one sheet and then seperate sheets for each team, so summarise their results.

Daddylonglegs helped me with a formula that meant I could enter the results in one page and they appear on the team sheet, but is there a way of searching the results page to have the results then entered on the team sheet?

I could do it manually, but that would be ok if I was only doing it for a few teams, but the thought of doing it for 20 teams seems huge.

I need a formula that would search down the 'home team' column as well as the 'away team' column

Thanks