Lookup:
- Retrieving required information to existing table from another table.
VLookup:
- Vlookup sorts information in vertical manner or a column information.
- For Example if you want phone number of particular person in table we use Vlookup.
- Below table we have details of people.
- In other sheet I am retrieving the people mobile number and Social Security.
Vlookup Left:
- Using a middle reference column to retrieve data.
- In below I used Employee Id to retrieve data.
- As it is second column normal vlookup cannot perform this action.
- We use VlookupChoose to perform this.
- Below two table EmployeData, Sheet2 to retrieve information.
- Retrieved Designation from Sheet2.
- Retrieved Phone Number, Name from EmployeData.
HLookup:
- Hlookup sort the information in a row manner.
- For Example If you want email id of all peoples we use Hlookup.
- From the above table, I am retrieving the email address of all the people.
