Advertisement
NonplayerCharacter

Spreadsheets | VLOOKUP

Dec 11th, 2018
286
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.15 KB | None | 0 0
  1. =IF(ISERROR(VLOOKUP(B1, A:A, 1, FALSE)), FALSE, TRUE)
  2. /*
  3. check whether the value of B1 is anywhere in column A
  4. if true, print TRUE, else print FALSE
  5. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement