Thread: Use of named ranges based on cell content
View Single Post
 
Old 02-25-2019, 12:02 AM
alpha alpha is offline Windows 10 Office 2010 64bit
Novice
  
Join Date: Jun 2018
Posts: 18
alpha is on a distinguished road
Default
Quote:
Originally Posted by Intruder View Post
Formula, that does not do the job, would be something like ="sub_"&A1 +5 ...
Instead of that, you can use:
Code:
=indirect("sub_"&A1)+5
Reply With Quote