How to search text x 2 in same column and return 2nd result

Hi,

I have some imported data that I need to clean up. The problem I have is that I need to be able to search for specific text in the same column & search for one word in a cell which is approximately 62 rows below returning the cell that i'm searching the one word in.

Example: Search "Name Header" (A1) & Search "Total" (A63) to return "Total Price £1719" (A63)

Total Price cell may not always be in A63 & Header may not always be in A1, as this is a data import, the cells may move around & I need to be able to pin them down to a static point to link them to an overview page.

Any help that anyone can offer would be greatly appreciated.

Many thanks.