Related:
- Excel (Searching, Finding and Returning)
- Vba excel search - How-To - Excel
- Excel - Search & Display query - How-To - Excel
- Excel - Search for duplicate in adjacent columns - How-To - Excel
- Excel search bar missing - How-To - Excel
- VBA Excel Search Select Paste Delete ✓ - Forum - Excel
2 replies
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
Rick
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.
Thank you for replying so quickly
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.
Thank you for replying so quickly
Subscribe To Our Newsletter!
