If Function. How to Add more criteria

[Corey]

Is it posible to add more If functions to a single If calc ?

I need to add, if i can to the below :
=IF(D58=R69,AJ69,IF(D58=R70,AJ70,IF(D58=R71,AJ71,IF(D58=R72,AJ72,IF(D58=R73,AJ73,IF(D58=R74,AJ74,IF(D58=R75,AJ75,IF(D58=R76,AJ76))))))))

I want to add about another 26 IF's to this.

Can i some how?


If i try anymore i get an error, but the above seems to be the limit.

--
Regards

Corey

[VBA Noob]

HI

The attached should help

http://www.j-walk.com/ss/excel/usertips/tip080.htm

http://www.cpearson.com/excel/nested.htm

VBA Noob

[Biff]

Hi!

Try this:

=INDEX(AJ69:AJ102,MATCH(D58,R69:R102,0))

Biff

"Corey" <[email protected]> wrote in message
news:[email protected]...
> Is it posible to add more If functions to a single If calc ?
>
> I need to add, if i can to the below :
> =IF(D58=R69,AJ69,IF(D58=R70,AJ70,IF(D58=R71,AJ71,IF(D58=R72,AJ72,IF(D58=R73,AJ73,IF(D58=R74,AJ74,IF(D58=R75,AJ75,IF(D58=R76,AJ76))))))))
>
> I want to add about another 26 IF's to this.
>
> Can i some how?
>
>
> If i try anymore i get an error, but the above seems to be the limit.
>
> --
> Regards
>
> Corey
>

[Corey]

thanks Biff

To easy once ya know....


Corey.....

[Biff]

You're welcome!

Biff

"Corey" <[email protected]> wrote in message
news:uKH%[email protected]...
> thanks Biff
>
> To easy once ya know....
>
>
> Corey.....
>

[Bob Phillips]

=INDEX(AJ69:AJ76,MATCH(D58,R69:R76,0))

just extend the 76 part.

If it might not match add error checking

=IF(ISNA(MATCH(D58,R69:R76,0)),"No
match",INDEX(AJ69:AJ76,MATCH(D58,R69:R76,0)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Corey" <[email protected]> wrote in message
news:[email protected]...
> Is it posible to add more If functions to a single If calc ?
>
> I need to add, if i can to the below :
>
=IF(D58=R69,AJ69,IF(D58=R70,AJ70,IF(D58=R71,AJ71,IF(D58=R72,AJ72,IF(D58=R73,
AJ73,IF(D58=R74,AJ74,IF(D58=R75,AJ75,IF(D58=R76,AJ76))))))))
>
> I want to add about another 26 IF's to this.
>
> Can i some how?
>
>
> If i try anymore i get an error, but the above seems to be the limit.
>
> --
> Regards
>
> Corey
>
>