Hi

Can anyone tell how to copy a cell from one row, based up information from
another row?

An example is the following:
A B C D E
Row 1 Test test2 test3 test4 test5
Row 2 yes

so the formula would look at Row 2, see that there is "yes" in cell C2 and
copy the text from row 1 (C1). There will only ever be one box filled in in
row 2

I'm using Excel 2003

Any help would be greatly appreciated!
Rachael