Mark in Boston
New Member
- Joined
- Aug 14, 2003
- Messages
- 18
A formula uses a named a range but it needs to be expanded. I have tried highlighting the range and renaming it but that does not work. Any ideas? Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Edit a named range to include more cells?
- Thread starter Mark in Boston
- Start date
HintonGrange
New Member
- Joined
- Jan 8, 2019
- Messages
- 1
Thank you also from me in 2019! I have just found it and used it 
Upvote
0
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Well, here it is 2020 and this is STILL helping! Was driving myself crazy trying to figure out how to extend a range in an Excel 2003 spreadsheet. Definitely not intuitive and help was not useful. Was about to give up when I stumbled up your post. Thank you, thank you, thank you!!!
Upvote
0
