In excel how the LOOKUP formula works?

Here's an example: you want a person phone number so you open the address book and search his name to find the phone number attached to his name.

That's how LOOKUP functions work, you give it a piece of information to find another information related to it.

There are many LOOKUP functions like

• Vlookup
• Hlookup
• Index
• Match
• Index Match
• Offset Match