if function error

[AHizon via OfficeKB.com]

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"

 

[Don Guillett]

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

 

[Teethless mama]

Try this:

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

 

[AHizon via OfficeKB.com]

Thanks that works...Thanks so much!!

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"