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

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

FAQ

Thread Tools

Display Modes

03-06-2019, 01:10 PM

nielsgeode nielsgeode is offline

Windows 7 64bit Excel 2016: make a cell value from the number in a different cell

Office 2010 32bit

Advanced Beginner

Join Date: Apr 2017

Posts: 42

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?

« Previous Thread | Next Thread »

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
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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:28 AM.