Help me regarding formula which i am going using

[mebro]

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)

 

[steve the fish]

See if this works:

=IF(INDEX(UserTable,MATCH(TRUE,INDEX(EXACT(B5,UserName),0),0),2)=B6,TRUE,FALSE)

 

[mebro]

it's working, Thanks Steve.

 

[mebro]

Hi Steve
Iam facing another issue, it is not showing false when it's not matched.its showing #N/A instead false

 

[mebro]

Hello Steve
Nevermind,I have validated it in the code

 

[mebro]

Hello Steve,

I need to validate the same(case sensitivity check) with the UserTable column with the value in B6, Can you please help me on this below is the formula I am using, but I am not getting the correct value.

=IF(INDEX(UserTable,MATCH(TRUE,INDEX(EXACT(B5,UserName),0),0),2)= MATCH(TRUE,INDEX(EXACT(B6,UserTable),2),0),TRUE,FALSE)