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.

Originally Posted by contaminated

Hi
Maybe this

=CONCATENATE(INDEX(A:A,MATCH("Header *",A:A,0)),"/",INDEX(A:A,MATCH("Total Price *",A:A,0)))

That works, thank you, the only problem is that the example I posted was one of about 30 searches on the same page so I need it to look for the header first & then the first instance of "Total Price" below it - is this something that can be adapted easily? At present, its returning the result of the search above it.

Sorry, I didn't mention that on my original post.