Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@IwonGunawan

IwonGunawan/left_lookup.xlsx

Last active September 15, 2020 19:34
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 IwonGunawan/c7228a911182e328a2468081e9c6c5a6 to your computer and use it in GitHub Desktop.
Save IwonGunawan/c7228a911182e328a2468081e9c6c5a6 to your computer and use it in GitHub Desktop.
Download ZIP
Left Lookup
Raw
left_lookup.xlsx
INDEX($F$2:$F$340, MATCH(A4,$G$2:$G$340,0))
$F$2:$F$340 = index data yang ingin dicari
A4 = keyword (bisa di drag)
$G$2:$G$340 = parameter data
example file :
https://github.com/IwonGunawan/simpatda_api/blob/master/_archive/Left%20Lookup.xlsx
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment