Data Validation Custom with V Lookup
But nothing prevents using it there! Entries will be limited, a drop-down is
an additional bonus. My advice is: When you want to limit entries to limited
number of discrete values, always use data validation list.
Arvi Laanemets
"T. Valko" wrote in message
...
Yeah, do that for a drop down list but that's not what they want.
--
Biff
Microsoft Excel MVP
"Arvi Laanemets" wrote in message
...
Hi
Define lookup values as name (InsertNameDefine), and use defined name
as source for Data Validation List, like =MyName, (this allow you to
refer to other sheets in workbook)
Arvi Laanemets
"Scott R" wrote in message
...
Hi Everyone, I am a bit confused here.. trying to have a cell validated
to
only allow between 2 numbers (depending on the vlookup).. i have tried a
formula below which wont work.. not sure if i can even do such a
validation?
any help on this would be greatly appreciated..
=IF(J41="hannan",'=(VLOOKUP(C41,'Insert
Label'!W3:Y8,2,0))'<=(vlookup(c41,'insert label'!w3:y8,3,0))," ")
|