Thread: Excel 2016: make a cell value from the number in a different cell
View Single Post
 
Old 03-06-2019, 01:10 PM
nielsgeode nielsgeode is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
  
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