Excel (Searching, Finding and Returning)Closed

Question

Hi 

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?

Rick

rizvisa1 · Answer

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 · Answer

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

Excel (Searching, Finding and Returning)

2 responses

Similar discussions

Subscribe To Our Newsletter!