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
