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)

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)

=MATCH(number_cell,hidden_table_range,0)

should do it

--
__________________________________
HTH

Bob

"ozalid" wrote in message
...
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)

Many thanks guys. Have just ordered 'Dummies' from the Bay!

Regards, Alan

'the Bay'? Can you enlighten an unknowing Brit?

--
__________________________________
HTH

Bob

"ozalid" wrote in message
...
Many thanks guys. Have just ordered 'Dummies' from the Bay!

Regards, Alan

Ebay I suspect

"Bob Phillips" wrote:

'the Bay'? Can you enlighten an unknowing Brit?

--
__________________________________
HTH

Bob

"ozalid" wrote in message
...
Many thanks guys. Have just ordered 'Dummies' from the Bay!

Regards, Alan

of course!


"Mike H" wrote in message
...
Ebay I suspect

"Bob Phillips" wrote:

'the Bay'? Can you enlighten an unknowing Brit?

--
__________________________________
HTH

Bob

"ozalid" wrote in message
...
Many thanks guys. Have just ordered 'Dummies' from the Bay!

Regards, Alan

Here in Canada "the Bay" is the Hudson's Bay Dept. store.


Gord

On Tue, 28 Oct 2008 14:13:53 -0000, "Bob Phillips"
wrote:

of course!


"Mike H" wrote in message
...
Ebay I suspect

"Bob Phillips" wrote:

'the Bay'? Can you enlighten an unknowing Brit?

--
__________________________________
HTH

Bob

"ozalid" wrote in message
...
Many thanks guys. Have just ordered 'Dummies' from the Bay!

Regards, Alan

You may find that updates to the worksheet will be easier if you put that table
on a separate, dedicated worksheet.

It'll make inserting/deleting rows and columns much safer.

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)

--

Dave Peterson