
20 April 2017
The tutorial explains the basics of lookup in Excel, shows the strengths and weaknesses of each Excel lookup function and provides a number of examples to help you decide which lookup formula is best to be used in a particular situation.
The lookup functions discussed are:
LOOKUP
.VLOOKUP
.HLOOKUP
.VLOOKUP MATCH
.HLOOKUP MATCH
.OFFSET MATCH
.OFFSET MATCH MATCH
.INDEX MATCH
.INDEX MATCH MATCH
.
Full article: Lookup in Excel: Functions and formula examples