Hi all,

I have a table for our company tag rugby league which outlines each team in column A, the rest of the columns relate to opponents of these teams each gameweek.

In the workbook I also have a fixtures page where I can enter scores and this will update a further sheet which is the league table.

What I want to do is find the teams entered in the gameweek table in the league and relay their current position in the league. This will enable me to see which teams have hard or easy runs of games coming up according to the teams they are due to play.

Hope I havent made this too confusing and thanks to anyone who takes their time to read it!

kildareman