Not with data validation. You can have an adjacent cell that does a vlookup
on the client name, or if it is on the right of the client number, you can
use =index(ClientNumberRange,Match(validationCell,Clie ntNameRange,0),1)

while waiting for a selection in the data validation cell

=if(validationcell="","",index(ClientNumberRange,M atch(validationCell,Client
NameRange,0),1))

--
Regards,
Tom Ogilvy




"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:58bcdcf16033d@uwe...
Hi Tom,

Is there also a way to do the following:

ist 2 columns (for example 'client number' and 'name') in the validation
field.
When a client is chosen, only use the client number to fill the cell with.
Thanks,
Pierre


Pierre wrote:
Thanks Tom, works great.
Pierre

Insert = Name = Define

[quoted text clipped - 16 lines]
Thanks,
Pierre

--
Message posted via http://www.officekb.com