ADVANCED VLOOKUP CHEAT SHEET
[Pages:1]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 excel tips tricks queen s u
- excel formulas cheat sheet microsoft excel online
- excel 2016 formulas functions
- intermediate excel formulas and other tips and tricks
- vlookup lookup value table array col index num range
- pivot table cheat sheet microsoft excel online courses
- your excel formulas cheat sheet 15 tips for calculations
- 102 useful excel formulas cheat sheet pdf free download
- microsoft excel training connection
- how to use vlookup in excel productivity portfolio
Related searches
- cheat sheet for word brain game
- macro cheat sheet pdf
- logarithm cheat sheet pdf
- excel formula cheat sheet pdf
- excel formulas cheat sheet pdf
- excel cheat sheet 2016 pdf
- vba programming cheat sheet pdf
- macro cheat sheet food
- free excel cheat sheet download
- onenote cheat sheet pdf
- punctuation rules cheat sheet pdf
- excel formula cheat sheet printable