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)