Hi All,
please help me regarding the below formula which I am using to validate the login credentials.
In below case, it's not checking for case sensitivity. it's allowing both(Let's take an example in the username range table I have name "Testing" and when I enter "testing" at B5 it's allowing). I do not have any option to upload the screenshot or file here.
IF(INDEX(UserTable,MATCH(B5,UserName,0),2)=B6,TRUE,FALSE)
please help me regarding the below formula which I am using to validate the login credentials.
In below case, it's not checking for case sensitivity. it's allowing both(Let's take an example in the username range table I have name "Testing" and when I enter "testing" at B5 it's allowing). I do not have any option to upload the screenshot or file here.
IF(INDEX(UserTable,MATCH(B5,UserName,0),2)=B6,TRUE,FALSE)