New answers tagged

0 votes

How do i utilize IF functions (or others) in order to create a simple username/password in google sheets?

Username to test in A3 Pin to test in B3 Username list in A5:A Pin list in B5:B =IFNA(IF( VLOOKUP(A3, A5:A, 2, 0)=B3, "verified", "invalid-A"), "invalid-B") ...
Blindspots's user avatar
  • 3,380

Top 50 recent answers are included