You are repeating work in the TRIM statements. Possibly doing the trim on
all 3000 rows for each row you are trying to match. You are also repeating
work in the Match.
You must calculate intermediate results once and save them to intermediate
ranges.

Suggestion: Bring over TRIM('JNP'!$A$1:$A$3000) once into another range
"TrimmedA" in the matching worksheet. Likewise for TrimmedD
Save the result {TrimmedA=Trim(Fx:Fy)}into TrimA01.
Save the result of TrimA01*TrimmedD into TrimRow.
Finally save the Match into a range: MATCH(1,(TRimRow=TRIM(K8)),0) --
range MatchRow
Now your formula becomes: =IF(ISNA(Matchrow),"
",INDEX('Jets Jobs in Process'!$C$1:$C$2988,Matchrow,1)

-Stephen Rasey
Houston

"Little Penny" wrote in message
...
I have a worksheet that uses 3 index and match array formulas
referencing two different worksheets (JNP) and (Shipped) in the same
workbook to update its information.