New answers tagged windows
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")
...
- 3,380
Top 50 recent answers are included