View Single Post
 
Old 11-01-2019, 08:15 AM
Drywit44 Drywit44 is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2018
Location: New York, NY
Posts: 12
Drywit44 is on a distinguished road
Default how to return a value from a row selected by row above

My top row is 2020, 2021, etc. My second row are balances in a brokerage account that grows over time. In C1, I want to type a year. In C2 I want Excel to return the value of the account in that given year. Can Excel do this?

Many thanks.
Reply With Quote