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.
.