Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2019, 08:15 AM
Drywit44 Drywit44 is offline how to return a value from a row selected by row above Windows 10 how to return a value from a row selected by row above Office 2016
Novice
how to return a value from a row selected by row above
 
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
  #2  
Old 11-01-2019, 12:29 PM
Logit Logit is offline how to return a value from a row selected by row above Windows 10 how to return a value from a row selected by row above Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Yes. Search for HLOOKUP or just simply FIND or SEARCH in VBA.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro - Copying and Pasting selected slides (based on selected keywords/criteria) Hi erickhawe PowerPoint 0 08-16-2019 09:00 PM
Powerpoint-2019 Text in selected theme remains in All Caps even when small caps option is selected Tanasha4 PowerPoint 2 04-06-2019 07:53 PM
numbered list: bold when selected and fade when selected following number village PowerPoint 0 11-08-2017 10:43 AM
Return Entire Row ibrahimaa Excel 3 01-10-2012 05:44 AM
Return to in box cjwilson2740 Outlook 0 04-05-2010 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft