ADVANCED VLOOKUP CHEAT SHEET - Excel off the grid
ADVANCED VLOOKUP CHEAT SHEET
BASIC VLOOKUP
=VLOOKUP( lookup_value , table_array , col_index_num , range_lookup )
Can be "text" or cell reference
1
234
TRUE = Approximate Match (Sorted Data)
FALSE = Exact Match
FASTER CALCULATION
=IF(VLOOKUP(lookup_value, table_array, 1, TRUE)=lookup_value, VLOOKUP(lookup_value, table_array, col_index_num, TRUE), NA())
LEFT LOOKUP ? Array Formula {Ctrl+Shift+Enter}
{=VLOOKUP(lookup_value, CHOOSE({1,2}, lookup_range1 , lookup_range2 ), 2, FALSE)}
CHANGE COLUMN NUMBER
2
1 34
=VLOOKUP(lookup_value, table_array, COLUMN(lookup_return_column)-
COLUMN(first_column)+1, range_lookup)
MULTIPLE CRITERIA ? Array Formula {Ctrl+Shift+Enter}
{=VLOOKUP(lookup_value_A & lookup_value_B, CHOOSE({1,2}, lookup_range1_A & lookup_range1_B, lookup_range2), 2 , FALSE)}
ROWS AND COLUMNS
=VLOOKUP(lookup_value, table_array, MATCH(column_lookup_value, column_header_array, 0)+1, FALSE)
WILDCARDS
lookup_value: ? = Single Character * = Any number of Characters
Save time and achieve more with Excel at
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- microsoft 2formulas functions and formatting
- excel 2010 advanced
- excel intermediate training packet shasta coe
- useful microsoft excel functions formulas webhome
- advanced excel pivot tables university of exeter
- excel formulas
- excel advanced
- sum formula in excel
- advanced vlookup cheat sheet excel off the grid
- commonly used excel functions
Related searches
- excel formula cheat sheet pdf
- excel formulas cheat sheet pdf
- excel cheat sheet 2016 pdf
- free excel cheat sheet download
- excel formula cheat sheet printable
- excel macro cheat sheet pdf
- vba excel cheat sheet pdf
- microsoft excel cheat sheet pdf
- excel 2016 cheat sheet pdf
- excel 2016 cheat sheet printable
- vlookup cheat sheet pdf
- excel cheat sheet printable