I could not post the page but did the next best thing:
Broker contact person
Broker contact number
Building (Additional Dwelling)
This is Column A, I would like Cell D6=(cell below "Sum Insured:") ,but "Sum Insured:" is never in the same cell location, ie A23, and the cell below can be 1 of 100 texts.
What I basically need is for it to Search Column A, Find "Sum Insured:" and return "Buildings (Additional Dwelling)" for this example.
Thank you for replying so quickly