Skip to content

Instantly share code, notes, and snippets.

@tsubauaaa

tsubauaaa/string_category.xlsx

Last active November 4, 2015 04:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tsubauaaa/a2243d6487953a108531 to your computer and use it in GitHub Desktop.
Save tsubauaaa/a2243d6487953a108531 to your computer and use it in GitHub Desktop.
Download ZIP
If that contain the string , classified into each of its string.
Raw
string_category.xlsx
=IFERROR(VLOOKUP(LOOKUP(0,0/FIND(Sheet1!$A$2:$A$8,B2),Sheet1!$A$2:$A$8),Sheet1!$A$2:$B$100,2,0),"N/A")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment