I'm trying to use the if function to grab the corresponding value (2 rows
below) that matches the month of the current date. I have the following
formula but get an error message. If I reduce the criteria to 8 or less the
function will work, but not if I have more than 8 if statements. Can anyone
help me condense the formula for Excel 2007 to understand?
Jan = C4
Feb = D4
Mar = E4
Apr = F4
May = G4
Jun = H4
Jul = I4
Aug = J4
Sep = K4
Oct = L4
Nov = M4
Dec = N4

Function=IF(O3=C4,C6,IF(O3=D4,D6,IF(O3=E4,E6,IF(O3 =F4,F6,IF(O3=G4,G6,IF(O3=H4,
H6,IF(O3=I4,I6,IF(O3=J4, J6,IF(O3=K4, K6,IF(O3=L4, L6,IF(O3=M4, M6,N6)))))))))
))

Error Msg: "The specified formula cannot be entered because it uses more
levels of nesting than are allowed in the current file format"

--
Message posted via http://www.officekb.com

Suggest you have a look in the help index for MATCH. to lookup o3 in c4:m4
and INDEX row 6 with the match.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AHizon via OfficeKB.com" <u38169@uwe wrote in message
news:8a013e912d2eb@uwe...
I'm trying to use the if function to grab the corresponding value (2 rows
below) that matches the month of the current date. I have the following
formula but get an error message. If I reduce the criteria to 8 or less
the
function will work, but not if I have more than 8 if statements. Can
anyone
help me condense the formula for Excel 2007 to understand?
Jan = C4
Feb = D4
Mar = E4
Apr = F4
May = G4
Jun = H4
Jul = I4
Aug = J4
Sep = K4
Oct = L4
Nov = M4
Dec = N4

Function=IF(O3=C4,C6,IF(O3=D4,D6,IF(O3=E4,E6,IF(O3 =F4,F6,IF(O3=G4,G6,IF(O3=H4,
H6,IF(O3=I4,I6,IF(O3=J4, J6,IF(O3=K4, K6,IF(O3=L4, L6,IF(O3=M4,
M6,N6)))))))))
))

Error Msg: "The specified formula cannot be entered because it uses more
levels of nesting than are allowed in the current file format"

--
Message posted via http://www.officekb.com

Try this:

=HLOOKUP(O3,C4:N6,3,)



"AHizon via OfficeKB.com" wrote:

I'm trying to use the if function to grab the corresponding value (2 rows
below) that matches the month of the current date. I have the following
formula but get an error message. If I reduce the criteria to 8 or less the
function will work, but not if I have more than 8 if statements. Can anyone
help me condense the formula for Excel 2007 to understand?
Jan = C4
Feb = D4
Mar = E4
Apr = F4
May = G4
Jun = H4
Jul = I4
Aug = J4
Sep = K4
Oct = L4
Nov = M4
Dec = N4

Function=IF(O3=C4,C6,IF(O3=D4,D6,IF(O3=E4,E6,IF(O3 =F4,F6,IF(O3=G4,G6,IF(O3=H4,
H6,IF(O3=I4,I6,IF(O3=J4, J6,IF(O3=K4, K6,IF(O3=L4, L6,IF(O3=M4, M6,N6)))))))))
))

Error Msg: "The specified formula cannot be entered because it uses more
levels of nesting than are allowed in the current file format"

--
Message posted via http://www.officekb.com

Thanks that works...Thanks so much!!

Teethless mama wrote:
Try this:

=HLOOKUP(O3,C4:N6,3,)

I'm trying to use the if function to grab the corresponding value (2 rows
below) that matches the month of the current date. I have the following
[quoted text clipped - 20 lines]
Error Msg: "The specified formula cannot be entered because it uses more
levels of nesting than are allowed in the current file format"

--
Message posted via http://www.officekb.com