A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 03:51 PM posted to microsoft.public.excel.worksheet.functions
Dalcin
external usenet poster
 
Posts: 2
Default 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.

  #2  
Old May 25th, 2010, 05:15 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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.


  #3  
Old May 25th, 2010, 07:14 PM posted to microsoft.public.excel.worksheet.functions
Dalcin
external usenet poster
 
Posts: 2
Default 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.


.

  #4  
Old May 25th, 2010, 07:48 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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.


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.