Hi, I am trying to link a dynamic range, using data validation, the initial part to get a value from col E from a user input of a value for col A works fine :

=VLOOKUP($C$32,'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!$A$2:$E$599,5,FALSE)

I now want the user to be able to select his value for colA from a droplist of values in colA. I have a named range and have defined refers to as:

'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!$A$1:$A$600

This works fine initally, but on reopening workbook it fails - seems to only work when the linked workbook is open.

I want to dynamically define this range - have tried this, but it wont happen :

'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!OFFSET($A$1,0,0,COUNTA($A:$A),1)

Any help much appreciated