To keep in just one cell all values related to a monthly rate
 

I have to update in a monthly basis a currency rate.
I know that there is a function, formula (or something like that) to link a
month descripton to a number.
e.g.
September09 1,325
October09 2,235
November09 1,258
I would like to select correspondent month and the cell be updated with the
value.

To keep in just one cell all values related to a monthly rate
 

Data Validation dropdown list for choosing the month combined with a lookup
table and VLOOKUP function.

For help on creating data validation dropdown lists see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlDataVal01.html

For help on VLOOKUP to populate the currency rate after choosing a date
see also at Debra's site.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 07:51:01 -0700, Dalcin wrote:

I have to update in a monthly basis a currency rate.
I know that there is a function, formula (or something like that) to link a
month descripton to a number.
e.g.
September09 1,325
October09 2,235
November09 1,258
I would like to select correspondent month and the cell be updated with the
value.

To keep in just one cell all values related to a monthly rate
 

First of all: Thank you very much for your answer!
I tried Data Validation but I don't know how "to link" the month to the value.
I would like to select the month in the drop down list and as result a cell
shows up just the value linked to the month.

"Gord Dibben" escreveu:

Data Validation dropdown list for choosing the month combined with a lookup
table and VLOOKUP function.

For help on creating data validation dropdown lists see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlDataVal01.html

For help on VLOOKUP to populate the currency rate after choosing a date
see also at Debra's site.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 07:51:01 -0700, Dalcin wrote:

I have to update in a monthly basis a currency rate.
I know that there is a function, formula (or something like that) to link a
month descripton to a number.
e.g.
September09 1,325
October09 2,235
November09 1,258
I would like to select correspondent month and the cell be updated with the
value.

.

To keep in just one cell all values related to a monthly rate
 

That's what VLOOKUP is used for.

Did you look at Debra's site for help on that function?


Gord



On Tue, 25 May 2010 11:14:06 -0700, Dalcin wrote:

First of all: Thank you very much for your answer!
I tried Data Validation but I don't know how "to link" the month to the value.
I would like to select the month in the drop down list and as result a cell
shows up just the value linked to the month.

"Gord Dibben" escreveu:

Data Validation dropdown list for choosing the month combined with a lookup
table and VLOOKUP function.

For help on creating data validation dropdown lists see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlDataVal01.html

For help on VLOOKUP to populate the currency rate after choosing a date
see also at Debra's site.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 07:51:01 -0700, Dalcin wrote:

I have to update in a monthly basis a currency rate.
I know that there is a function, formula (or something like that) to link a
month descripton to a number.
e.g.
September09 1,325
October09 2,235
November09 1,258
I would like to select correspondent month and the cell be updated with the
value.

.