Microsoft Office Forums Excel 2016: make a cell value from the number in a different cell

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2019, 01:10 PM
nielsgeode nielsgeode is offline Excel 2016: make a cell value from the number in a different cell Windows 7 64bit Excel 2016: make a cell value from the number in a different cell Office 2010 32bit
Advanced Beginner
Excel 2016: make a cell value from the number in a different cell
 
Join Date: Apr 2017
Posts: 42
nielsgeode is on a distinguished road
Default Excel 2016: make a cell value from the number in a different cell

if Sheet1!A1 has the value 50, I would like to enter a formula that points to Sheet2!B50 because 50 is in A1. I cannot enter B50 directly, Excel has to take the '50' from A1.




How can i do this?
Reply With Quote
  #2  
Old 03-07-2019, 12:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel 2016: make a cell value from the number in a different cell Windows 7 64bit Excel 2016: make a cell value from the number in a different cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Perhaps
=INDEX(Sheet2!B1:B50,A1)
to avoid INDIRECT which is volatile
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Increase number in cell, based on value in adjacent cell scottyb Excel 3 02-02-2017 03:51 AM
Data validation,force cell to be filed with number if respective cell is not empty nicholes Excel Programming 0 08-01-2015 09:08 AM
Excel 2016: make a cell value from the number in a different cell Entering a number in a cell causes it to fill with the color of a nearby cell Bill Martz Excel 1 04-23-2015 07:57 PM
Excel 2016: make a cell value from the number in a different cell Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? bharathkumarst Excel 7 10-13-2014 10:25 AM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM


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


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