Months & values

  • Thread starter Thread starter HandiMann
  • Start date Start date
H

HandiMann

need to write a formula that would show a specific value based on
month.

A B

January=0.955
February=0.996
March =1.027

I want to write a formula that recognizes the month in a specific cell
and returns a specified value.


Any help is greatly appreciated!
 
If the cell is A1 and the value is a date as in 01/18/2004 for example

=VLOOKUP(TEXT(A1,"mmmm"),{"January",0.955;"February",0.996;"March",1.027},2,
0)

if you want it for the whole year I am sure you could just add the necessary
months and values

If the value is text like in January

=VLOOKUP(A1,{"January",0.955;"February",0.996;"March",1.027},2,0)
 
How do you work out what value each month should take? Jan->Fe
difference is +.041, Feb->Mar difference is +.031

What would the difference for Mar->Apr be. +.021?

-Bo
 
Still not working. I am creating a heating budget and every month has a
efficiency factor. I want to be able to enter say "January" or 1/05/04
in one cell and have another cell display the efficiency factor value
for "January" etc. etc.

Is this even possible??? :confused:
 
Hi

If I was doing it, I would type the data into 12 cells and name each cell,
from January through to December. Then you can just use =january to get the
value.

Andy.
 
Your suggestion worked out great I messed up when adding the othe
months. But is working out. Greatly appreciated
 
Back
Top