Hi there, I'm trying to automate a process that I've always done manually in the past.

I look after the weekly scores from a quiz league and receive a worksheet with the names of the teams and their scores.

The problem I have is that not all teams compete each week so their names and scores are not always there.

How can I get excel to look for a team name in a column and return the score of the adjacent cell into a different worksheet and next to the correct team name.

I thought I had it using simple IF functions but no progress there.

Can anyone suggest a way of doing this please.

I've got up to 600 team names now so it's a nightmare doing it by hand.

Thanks in advance.

ps this is the first time I've ever posted anything on an online forum so I hope I haven't broken any rules.

TB