Indirect and Offset argument
 

I have a customerlist in A1:A10,then choose insertNamedefine
name:customerlist, location: =offset(A1,0,0,3,1), SELECT dat
validation lists IN C3:"=indirect(customerlist),however exit erro
could you tell me how to sove this problem

--
qihongmin
-----------------------------------------------------------------------
qihongming's Profile: http://www.excelforum.com/member.php...fo&userid=1691
View this thread: http://www.excelforum.com/showthread.php?threadid=38148

Indirect and Offset argument
 

Try This:
Name the range: CustomerList
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A,1),COU NTA(Sheet1!$1:$1))
then in C3 go to DataValidationAllow: (Lists)Source:Click in cell and
then go to InsertNamePasteCustomerList

It worked for me. Hope it to works for you.
--
Though daily learning, I LOVE EXCEL!
Jennifer


"qihongming" wrote:


I have a customerlist in A1:A10,then choose insertNamedefine,
name:customerlist, location: =offset(A1,0,0,3,1), SELECT data
validation lists IN C3:"=indirect(customerlist),however exit erro,
could you tell me how to sove this problem?


--
qihongming
------------------------------------------------------------------------
qihongming's Profile: http://www.excelforum.com/member.php...o&userid=16914
View this thread: http://www.excelforum.com/showthread...hreadid=381483