Hi JE

OK, I have the following headings;
Assessee's Ratings, Legend/guide, use of equipment
Under Assessee's Rating a figure or 1,2,3,4 or five is entered into one of
the following 5 cells. Legend guide is as it says. Use of equipment has a
one of the follwing codes entered into the row where the numeral in column A
is entered. The letter/code could be ID, G, S, T,or P. The number and the
letter is entered by the assessor.

This is easy, just press the number or letter on th ekeyboard and it
appears. This is at the bottom of the spreadhsheet in the bosy and I want a
copy of these two cells to appear at the start as a summary. Does that make
it more clear?

Regards

Brad
"JE McGimpsey" wrote:

In article ,
WRT wrote:

I am unable to copy the entered code (text) from C20:C25 Please be aware
that if the entered number in A20:A25 is 3 (hypothetically) this does not
mean that the code (text) in C20:C25 will always be G (or any other code each
and every time).

Then you need to explain how the formula should determine which code
goes in the cell...