Finding a text and getting the cell below

[jakeedwards]

We have one column of information which is 500 lines long.

We need a formula to find a specific text we are searching for and then once that text has been found we need to get the cell directly below that which contains a value we need.

Any help would be greatly appreciated as we've been stuck on this,

Thanks, Jake.

 

[Rick Rothstein]

We need a formula to find a specific text we are searching for...

Is that "specific text" the only text in the cell or could it be in a cell along with other text around it?

Also, what is that "specific text" or, alternately, what cell is it in?

 

[jakeedwards]

Yes, the specific text is in a cell on it's own and it is the only word in the 500 lines. These lines change depending the data at the time as it refreshes live from a website therefore we cannot just link a cell it has to be the specific text.

We just need to somehow find that text and link the cell directly below (where the value lies) so that on our other page the refreshed value is displayed.

Currently our problem is that the cells on this page keep moving up and down and overtaking each other therefore data on the other page is displaying another cells value

Thanks,

 

[Rick Rothstein]

Yes, the specific text is in a cell on it's own and it is the only word in the 500 lines. These lines change depending the data at the time as it refreshes live from a website therefore we cannot just link a cell it has to be the specific text.

We just need to somehow find that text and link the cell directly below (where the value lies) so that on our other page the refreshed value is displayed.

Currently our problem is that the cells on this page keep moving up and down and overtaking each other therefore data on the other page is displaying another cells value

I am not exactly sure what your last paragraph means, but if your 500 rows of data is in Column A, this formula will get you the value under the cell containing "specific text"...

=INDEX(A1:A500,MATCH("specific text",A1:A500,0)+1)

 

[jakeedwards]

I am not exactly sure what your last paragraph means, but if your 500 rows of data is in Column A, this formula will get you the value under the cell containing "specific text"...

=INDEX(A1:A500,MATCH("specific text",A1:A500,0)+1)

Awesome, worked perfectly.

Cant thank you enough, thank you very much.. you've made my day