Hi,

Build a table out of the way that looks like the one below. I put mine in K1
- L5


The put this formula in a cell
=VLOOKUP(A1,K1:L5,2,FALSE)

If you now enter a number in A1 you get the corresponding day of the week.


1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday

Mike


"ozalid" wrote:

Sorry for this, I know it is simple, but its a long time since I used Excel!
I want a cell to reflect the value of another cell in a hidden table if I
use another cell as the reference. So for example, I have a table of days
Monday to Friday and in another cell I could put 1 which would refer to
Monday and put this value in another cell somewhere else on the sheet, but if
I change it to 2 I want it to put Tuesday etc, this sounds muddled to me, but
can anyone help please? I have been messing with this for ages.
Regards, Alan (Excel 2000)