I have not yet learned how to write working excel formulas very well, and I was looking for a short bit of help...
I would like an arbitrary cell (call it D6) to search Column A for text ("Sum Value:") and return the text in the cell below it.
I import text files which contain highly variable amounts of rows, the only way I can return the information I need is to find the cell above it in the same column, any suggestions?
Could you post the book where it is NOT pulling the data. One has to see the data to tell you the answer. there Could be space issue, non-printing character etc. So unless one see the data, hard to tell you. Post the file and paste thelink back here as you did before
I could not post the page but did the next best thing:
Broker
Broker contact person
Broker eÂmail
Broker contact number
Risk address
Erf Number
Contact person
Name
Contact Number
Cell
Sum Insured:
Building (Additional Dwelling)
Comments
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.