What Is The Use Of Vlookup And How Do We Use It?

1.	What Is The Use Of Vlookup And How Do We Use It?
Answer» Vlookup is used to find the data in the large spreadsheet by lookup value in ANOTHER WORKSHEET. To use the Vlookup function, we should have common values in both data. For example, we want to SEARCH the phone NUMBER of a PERSON. So, in order to find out the phone number, we will need the concerned persons name. Vlookup is used to find the data in the large spreadsheet by lookup value in another worksheet. To use the Vlookup function, we should have common values in both data. For example, we want to search the phone number of a person. So, in order to find out the phone number, we will need the concerned persons name.

Answer»

Vlookup is used to find the data in the large spreadsheet by lookup value in ANOTHER WORKSHEET. To use the Vlookup function, we should have common values in both data. For example, we want to SEARCH the phone NUMBER of a PERSON. So, in order to find out the phone number, we will need the concerned persons name.

Vlookup is used to find the data in the large spreadsheet by lookup value in another worksheet. To use the Vlookup function, we should have common values in both data. For example, we want to search the phone number of a person. So, in order to find out the phone number, we will need the concerned persons name.

Discussion

No Comment Found

Related InterviewSolutions

How To Protect The Macros You Create So People Cannot See Or Alter Them?
Tell Me About The Benefit Of Using Formula In Excel?
What Is The Quick Way To Return To A Specific Area Of Spreadsheet?
How Can You Resize The Column And Rows?
What Is A Macro In Excel?
How Can You Resize The Column?
How Can You Add, Rename Or Remove Worksheets?
What Are Worksheets?
What Types Of Workbook Protection Are Available?
Why Does Excel Have Two Macro Languages?