Skip to content

Instantly share code, notes, and snippets.

@YarnSeemannsgarn

YarnSeemannsgarn/match_and_indirect.vba

Last active August 29, 2015 14:10
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 YarnSeemannsgarn/95cd5862f6d45a2ff248 to your computer and use it in GitHub Desktop.
Save YarnSeemannsgarn/95cd5862f6d45a2ff248 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
match_and_indirect.vba
=IF(MATCH(N2, NP!I:I, 0), INDIRECT("NP!H" & MATCH(N2, NP!I:I, 0)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment