Loggin Form Xcelsius

[Former Member]

hello all,

I am trying to get the login form in the xcelsius. I have the user ids and password in sheet which will connect to xml file back.

My question is if i have the loggin details in the sheet, can i compare the values entered in the textbox with the one i have it in excel, if the information holds true then i will pass a group of object.

Group1 : loggin panel.

Grroup2 : set of components.

I tried using the vlookup formula in excel and compare with the one entered in textbox, but its failed.

Any one with the idea please... Thanks

[Former Member]

Hi Asif,

Try with Match function . Eg: Username starts from Row 3, column F and Password from column G.

User Name Password

abc abcd

xyz 1234

Entered Username stored in C4

Entered Password stored in C5

A1=IF(ISNUMBER(MATCH(C4,F3:F4,0)),1,0)

A2=IF(ISNUMBER(MATCH(C4,G3:G4,0)),1,0)

B1=MATCH(C4,F3:F4,0)

B2=MATCH(C4,F3:F4,0)

If(B1=B2) and (A1=A2) matches then "Login Succeeded" Else "Login Failed".

If Above two returns 1 then "Username" and "Password" is correct. Else Incorrect.

Eg: If "abc" and "abcd" entered as username and Password, Match will return 1. ISNUMBER will return true and IF will return 1.

Try this, It works.

Thanks,

Muthukumar A.S

Edited by: Muthukumar_BO on Dec 8, 2011 1:29 PM

Edited by: Muthukumar_BO on Dec 8, 2011 1:37 PM