In cell E13, I want to select the number from column B where I am happy with the data....this will change depending on the data, but I think it's irrelevant to this discussion.



Basically, I want cell E14, to see that cell E13's text is =B19 (I have just selected this as an example, it could be B24 or anything in the B column), and so E14 knows that it needs to show the data that is listed one below it, in cell B20. Then cell E15 looks for the number in B21 and displays it, E16 looks for the number in B22 and so on and so on.


I want a forumla, so E14 and below (and the subsequent columns) automatically populates when i enter the reference cell in E13, rather than having to drag the formula each time.


hope this helps clarify?