Hi All

This forum has been a very helpful source of answers to many "How to..." questions, but try as I might I cannot find the answer to this one. Hence this, my first post. Please be gentle - I'm an excel amateur. Using 2003. No knowledge of VBA. So apologies if I get this a bit wrong.

Here's what I'm trying to do.

I have a sheet called **Classes 1 - 91**. Each cell on this sheet contains a name, typed in as a text string. (The names are entrants in a competition, where points are awarded for first, second and third prizes. I'm using the cell reference to anonymise the entrants).

For example:

**J Smith** is in cell **C1**

**F Bloggs** is in cell **D2**

**A Jones** is in cell **E1**

**J Brown** is in cell **F7**

The second sheet in the workbook is called **Winners **and is set up to record the prizewinners. So the competition judge will give me a reference for the first prize winner, eg: D2. And what I'd like to do is type D2 into a cell on the **Winners **sheet, and have the name from that cell in sheet **Classes 1 - 91** be pulled through into a results cell. In this instance, it will display** F Bloggs** under my column heading for 1st prize.

Now the easy way is to use the formula ='Classes 1 - 91'!D2. But I want to idiot proof it, so don't want to have to type, copy or paste, or edit the formula each time. (There are 276 prizewinners to enter in total...)

Despite lots of looking and playing, I can't seem to find how to insert the !D2 into the formula by using D2 typed into a cell on the **Winners **sheet.

I've tried CONCATENATE, but while I can get it to add the two text strings together and return the result in a separate cell, the results cell doesn't use it as a formula, just displays it as text.

I've played with INDIRECT but don't really understand what it's doing.

Here's hoping that some of you Excel geniuses will find this easy, and make my day!

Kind regards

Ian