| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation on other sheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation in another sheet | Excel Discussion (Misc queries) | |||
| Data Validation List from different sheet | Excel Discussion (Misc queries) | |||
| data validation works in one sheet but not another | New Users to Excel | |||
| Data Validation fromanother sheet | Excel Discussion (Misc queries) | |||
| Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
Threaded Mode
