Need to add to current formula

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

HandiMann

I have this formula that will cause values to change based on the mont
that is referenced in the formula ($L$1). Currently the formul
is:=VLOOKUP($A$1,$AD$7:$AG$44,IF($L$1="January",2,IF($L$1="February",2,IF($L$1="March",2,IF($L$1="April",2,IF($L$1="MAY",4,IF($L$1="June",3,IF($L$1="July",3,0))))))),0)

I need to add August, September, October, November, & December to thi
formula but excel is not allowing me.

Does anyone know how I can get around this? Oh by the way
November thru April =2, May and October=4 and June thru September=
From a table.

Any help is greatly appreciated.:confused: :confused
 
Hi HandiMan,

Try this

If L1 hoilds a month string (i'll leave you to add the other months)

=VLOOKUP($A$1,$AD$7:$AG$44,MATCH($L$1,{"January","February","March","April"}
,0)+1,0)

If L1 holds a real date

=VLOOKUP($A$1,$AD$7:$AG$44,MONTH($L$1)+1,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi

I would create a seperate lookup table for your months / values and
replace the third parameter of your current VLOOKUP function with that:
=VLOOKUP($A$1,$AD$7:$AG$44,VLOOKUP($L$1,'Months'!$A$1:$B$12,2,0),0)

HTH
Frank
 
Hi

an you describe your problem with more detail. Maybe the lookup table
for the months has some error.
If you like, mail me your spreadsheet and I#ll have a look at it
Frank
 
Thanks for your help I figured out where I coming up with error and
used both suggestions.

Thanks a lot for the assistance
 
Back
Top