Hi there,
I would like to create an array of addresses based on adding the values in a range to a string. Excel resolves the array to a single value and returns a single address, rather than an array of addresses.
Given:
A_Range_of_Values = {2,4,5,6}
I would like:
{="SomeSheetName!A" & A_Range_of_Values}
To return:
{SomeSheetName!A2,SomeSheetName!A4,SomeSheetName!A5,SomeSheetName!A6}
Instead of:
SomeSheetName!A2
Any help with this or suggestions of a different approach would be appreciated.
Thanks folks,
Jason.
Bookmarks