Elementary question

[ozalid]

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)

 

[Mike H]

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

 

[Bob Phillips]

=MATCH(number_cell,hidden_table_range,0)

should do it

 

[ozalid]

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

Regards, Alan

 

[Bob Phillips]

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

 

[Mike H]

Ebay I suspect

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

--
__________________________________
HTH

Bob

 

[Dave Peterson]

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.

 

[Bob Phillips]

of course!

Ebay I suspect

 

[Gord Dibben]

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


Gord