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:
OFFSET MATCH MATCH.
INDEX MATCH MATCH.
Full article: Lookup in Excel: Functions and formula examples