Hello everyone,

I have a sheet that is full of formulas that search 500 records in a reference sheet, and return the record (string) that contains the exact text I am searching for. The formulas work great, however, now that I am searching all 999 rows for these matching strings, my CPU is maxing out at 100% for 15 minutes while it executes. I have attached the formula below, each cell(in the 5 columns I am populating) contains this exact formula with different cell references. (B2,B3,B4, etc)

My questions are as follows:

Am I doing something wrong here with my methodology?
Is there any way that I can improve these execution times?

=IF(ISBLANK(B5),"",TRIM(MID(LOOKUP(2,1/ISNUMBER(SEARCH(B5,'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999)),'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999),FIND("POLICE AGENCY THEFT REPORTED TO",LOOKUP(2,1/ISNUMBER(SEARCH(B5,'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999)),'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999)),FIND("POLICE AGENCY PHONE #",LOOKUP(2,1/ISNUMBER(SEARCH(B5,'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999)),'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999))-(FIND("POLICE AGENCY THEFT REPORTED TO",LOOKUP(2,1/ISNUMBER(SEARCH(B5,'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999)),'C:\Users\Admin\Downloads\[Risk_Excel_Export.xlsx]Sheet1'!$A$1:$A$999))+5))))