Forum Discussion
David_Tipping
Mar 15, 2021Copper Contributor
Validation rule required against an existing list but case sensative
Hi - I'm needing to validate data entry against values that are already in a separate worksheet, but need help with case sensitivity. The use is to validate land parcel agricultural field names (...
- Mar 15, 2021
Select A2:A1048576.
Change the data validation rule to one of type Custom, with formula
=EXACT(A2,INDEX('Valid Field Numbers'!$A$2:$A$10430,MATCH(A2,'Valid Field Numbers'!$A$2:$A$10430,0)))
See the attached version.
JKPieterse
Mar 15, 2021Silver Contributor
David_Tipping Simple enough using a custom validation formula, see attached.