|
|
#1
03-06-2019, 01:10 PM
|
|||
|
|||
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? 
|
|
#2
03-07-2019, 12:20 AM
|
||||
|
||||
|
Perhaps
=INDEX(Sheet2!B1:B50,A1) to avoid INDIRECT which is volatile
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Linear Mode
