Add additional criteria

[Pat]

In PurOrders!$T$24:$T$1000 either True or False is returned.

I want to add the above to the following formula where the result will only
display if PurOrders!$T$24:$T$1000 is True.

=IF(ISERROR(INDEX(PurOrders!$L$24:$L$1000,MATCH(Potting04!P7,PurOrders!$AI$2
4:$AI$1000,0))),"",INDEX(PurOrders!$L$4:$L$1000,MATCH(Potting04!P7,PurOrders
!$AI$4:$AI$1000,0)))

Thanking you in advance for your kind assistance.
Pat

 

[hgrove]

Pat wrote...
...

I want to add the above to the following formula where the
result will only display if PurOrders!$T$24:$T$1000 is True.

Unclear, but I'll guess you mean you want the first match in col AI fo
which the corresponding cell in col T is TRUE. If so, try the *array
formula

=IF(ISNUMBER(MATCH(1,PurOrders!$T$24:$T$1000
*(PurOrders!$AI$24:$AI$1000=Potting04!P7),0)),
INDEX(PurOrders!$L$4:$L$1000,
MATCH(1,PurOrders!$T$24:$T$1000
*(PurOrders!$AI$24:$AI$1000=Potting04!P7),0)),""