Find the end of a data set and reference adjacent cells.

[Pedro's PhD]

Hi Everyone,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have an issue with a large data set but will try to explain it the best I can. <o></o>
<o></o>
In my template, in column A, I have a measurement which continues all the way down to 1002 rows. E.g. A2=0.00, A3=0.01, A4=0.02, A5=0.03... and so on until A1002=10.00. <o></o>
<o></o>
I then paste a set of numbers into column B which varies each time on the number of rows it goes down. <o></o>
<o></o>
What I need is a formula that will identify the last number in column B and read the adjacent value in column A. This value needs to then be displayed in Cell C4.<o></o>
<o></o>
So if I paste data into column B, with the last data value in B10, I then need the formula in Cell C4 to display the value displayed in cell A10. <o></o>
<o></o>
Hope that makes sense.<o></o>
<o></o>
Thanks in advance....... Pedro<o></o>

 

[tweedle]

Try
C4: =INDEX(A1:A1002,COUNTA(B1:B1002))

 

[Pedro's PhD]

Hi Tweedle,
Thanks so much, works perfectly.

Pedro