Combine two formulas

[Ozzie2842]

I could use some assistance with building one formula out of two.

Formula #1 in cell I2: =(LEFT(B2,2). Formula #2 works from the results of formula #1.

Formula #2 in cell J2: =IF(I2="P0",$AA$4,IF(I2="P7",$AA$1, IF(I2="P8",$AA$2, IF(I2="P9",$AA$3))))

I'm just not getting the logic to make these two come together. Any help would be greatly appreciated.

Thanks

 

[tweedle]

Assuming J2 is intended to be the aggregate formula ...
try
=IF(LEFT(B2,2)="P0",$AA$4,IF(LEFT(B2,2)="P7",$AA$1, IF(LEFT(B2,2)="P8",$AA$2, IF(LEFT(B2,2)="P9",$AA$3))))

 

[Ozzie2842]

Twiddle, you are a master. Thank you