jeudi 29 mars 2018

Using VLOOKUP and IMPORTRANGE to find a match and return one of two potential values

I am trying to change the value of cell B1 depending on if cell A1's value is found in another spreadsheet. If there is a match, I want the cell to say "banned". If A1 isn't found in the other spreadsheet, I want it to say "active'.

I've been playing around with this

=if((VLOOKUP(A3,IMPORTRANGE("https://docs.google.com/xyz","ALL BANNED ACCOUNTS!$G$2:$G$300"),1,false))=A3,"Banned","Active")

and can only get it to return "Banned". If there is no match, it always returns #N/A.

How can I remedy this?

Thanks!

Aucun commentaire:

Enregistrer un commentaire