Nested if statements

  • Thread starter Thread starter Slip
  • Start date Start date
S

Slip

I was trying to do 12 nested if statements and the system
only lets me do 7. Is there another method that I can use
to do the following?
I want to check to see if I have a match on the month
January, and if I do I want to insert a value from the
January budget column into my current position, similarly
if it's Feb I want Feb data.

thanks ....
 
Month is a number, so you can use that as an index into the data.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
try the following
Assumptions
- cell A1 stores the date (e.g. 01/02/2004)
- sheet1 stores your monthly figures (col. A = January, col B =
February, etc.)
- row 2 on sheet 2 stores the data you want

Use the following formula
=OFFSET('sheet1'!$A$2,0,MONTH(A1)-1)
 
Back
Top