Using an array to create an array of addresses

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.

Hi again,

Realised my issue was deeper than this: the data in my equivalent of "A_Range_of_Values" was based on a match formula that referenced a complete row. Array functions don't operate on complete rows/columns.

Sorry to be a dork on my first post, everyone... :/

Cheers, Jason.