Categories
Mastering Development

Excel get last data in column and return value from different column

I have a table that I’ve created in excel that dynamically inputs data from a stock so my column A is growing every day.

I’m looking for a formula that will search column A for the last data available then return back that row’s column H. So based on the photo, it would return the value -0.14.

I’ve figured out how to get to the last cell with data in column A but can’t figure out how to pull information from that row’s column H (I can’t apply that same method to column H because that column has 0s throughout)

= INDEX(A:A,COUNT(A:A))

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *