Skip to content

Instantly share code, notes, and snippets.

@rpfilomeno
Created December 17, 2014 11:15
Show Gist options
  • Save rpfilomeno/db3e70144e1f0ec950fc to your computer and use it in GitHub Desktop.
Save rpfilomeno/db3e70144e1f0ec950fc to your computer and use it in GitHub Desktop.
MS Office Tricks
Check if value is in column range
=IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),FALSE, TRUE)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment