Pete, as suggested I placed the 'items' in cells I1 to I14 on page 2, and
then used column C for data input (A,B,C etc). The formula entered in cell B2
is '=INDEX(Sheet2!I$1:I$14,CODE(C2)-64) and this is working OK (if I enter F
in C2 then CLOCK is shown in B2 - this is exactly what I'm after.

My next problem is that I am now trying the same thing with column D. The
formula used is '=INDEX(Sheet2!K$1:K$14,CODE(E2)-64)' - column E is used to
input data and I have a list of 'Locations' on page 2 in cells K1:K14 - this
formula isn't working. Any ideas please?

Steve

"Pete_UK" wrote:

You're welcome, Steve.

Pete

On Jul 6, 10:05 am, stevejeffries
wrote:
Thanks Pete, I'll give it a try.