Skip to content

Instantly share code, notes, and snippets.

@btoone

btoone/gist:2289251

Created April 3, 2012 04:09
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 btoone/2289251 to your computer and use it in GitHub Desktop.
Save btoone/2289251 to your computer and use it in GitHub Desktop.
Download ZIP
Excel VLOOKUP usage
Raw
gistfile1
=VLOOKUP($F2,Sheet1!$D$2:$BL$1206,N1+1)
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup _value: The value you want to find in the first column of the table_array.
table_array: This is the table of data that VLOOKUP searches to find the information you are after.
The table_array must contain at least two columns of data. The first column contains the lookup_values.
col_index_num: The number of the column in the table_array that contains the data you want returned.
range_lookup: A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing False will return exact matches only.
http://spreadsheets.about.com/od/excelfunctions/qt/080722_vlookup.htm
@tkacprow
Copy link

Must read page on VLOOKUP:
http://www.analystcave.com/excel-vlookup-vs-index-match-vs-sql-performance/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment