Copying code down a column without all cell references updating.

@TMShucks: I think that you are referring to me in this post.....I'll assume so.... having a strange day

I saw your DV at the very end of trying to make my posting. I was examining the formula and thought to myself, hey, this can be replaced by the headers of the table! So, I selected the headers of the table and typed in PriceGroups and when I went into the Name Manager, there was the name but the definition wasn't what I wanted! Not thinking that the name had already been taken for the "actual" price groups, I proceeded to change the definition to that which I had intended. Using just the Headers part of the definition meant that columns could be added to the table without having to change the formula. I then clicked on B2 only to discover that I had "stolen" the definition for the DV! So, I created ProductCode for the DV and included the definition for it (same as your definition). However, the definition went into outer space or some place else as it didn't get included in the actual posting.

I was writing in sentence form with the formulae in the sentences using the Fx button to mark the formula as a formula.

I must have made a mistake because that definition and text were gone as I now see leaving only the name. I have had this happen a couple of times lately and I think I am hitting some weird key combination to make this happen.

My apologies for that! Your use of =Table1[[#Headers],[PG0]:[PGF]] is absolutely correct.

If you are referring to the DV in the left column, you can use the same table for the DV list and this will eliminate having to use the INDIRECT in the DV. Instead of having =INDIRECT("Table1[Product Code:]") for the DV formula you could define a name in the Name Manager.... lets call it Product. The definition would be =table1[Product Code:]

The DV formula would then be =Product

I hope that I'm not being a pest.