Hello Jen!

Try the following steps

1. Make a lookup table in sheet3 with the numbers 1 to 256 in column A (one for each column label in a sheet). In the next column, fill in the column labels (A, B, C, ... AA, AB, ..., IV). Call this table Column_Labels

(This can be done much faster than most people would imagine. Let me know if you need the steps.)

2. In sheet2 write the following formula. (I'm assuming that your array needs to be linked to cell A1 in sheet1 (Sheet1!$A$1).

=Sheet1!$A$1&VLOOKUP(COLUMN(),Column_Labels,2,0)&ROW()

This will concatenate the formula's host cell reference to the list item. Whenever you shift your array to another block of cells, the result will reflect the new cell references.

HTH

M. Habib

(PS Excel file attached - took about 5 minutes to create.)