Hi Aladin, I'm probably being dense here I know, but I can't get the last few values to work with
that - 12/13/14 to return A23/A26/A27. Is the Ops sequence wrong, or what am I missing here?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Aladin Akyurek" wrote in message
...
It looks like...

=INDEX($A$15:$A$27,B15)

"saturnin02" wrote in message
...
Hi,
I need to calculate If staments based on the formula below.
Unfortunately, there are too many nested IF statements.

How can I write this formula in a more intellignet way that will work?



=IF(B15=1,A15,IF(B15=2,A16,IF(B15=3,A17,IF(B15=4,A 18,IF(B15=5,A19,IF(B15=6,A

20,IF(B15=7,A21,if(B15=8,A22,IF(B15=9,A23,IF(B15=1 0,A24,IF(b15=11,A25,IF(B15
=12,A23,IF(B15=13,A26,IF(B15=14,A27)))))))

Tx,

Sat