Hi - I am looking to input a formula into cell AO161 which searches formulas in cell range H:H in a separate workbook (2nd snip below) for the text included in A161.
I would like cell AO to return the text included in cell A22 in 2nd snip, if the text is found within its formula.
The formula will then need to be dragged down to look for slightly different code in A162 within the same range H:H returning the adjacent cell in A:A in 2nd snip.
Basically looking for "G TB FY23'!AN161" within H22 formula, and returning A22. But done in a way so formula can autofill for different text to search for.
Can anyone advise if this can be done? Any help appreciated!!
I would like cell AO to return the text included in cell A22 in 2nd snip, if the text is found within its formula.
The formula will then need to be dragged down to look for slightly different code in A162 within the same range H:H returning the adjacent cell in A:A in 2nd snip.
Basically looking for "G TB FY23'!AN161" within H22 formula, and returning A22. But done in a way so formula can autofill for different text to search for.
Can anyone advise if this can be done? Any help appreciated!!