Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

In excel how the LOOKUP formula works?

user-image
Question added by Ratul Al Imran , Mis Officer , Crown Cement PLC
Date Posted: 2017/02/08
Salam Waddah
by Salam Waddah , Staff Software Engineer , Hello Chef

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

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.