answersLogoWhite

0

In excel, what is VLOOKUP?

User Avatar

Annie Shannon

Lvl 1
4y ago
Updated: 10/26/2020

It is an inbuilt function and it stands for vertical lookup.

Suppose you have two worksheets with information on for the same person. On each worksheet you have an identifying reference number for each person. Now suppose you wanted to use some of the information stored on worksheet 1 in worksheet 2. You could use vlookup in sheet 2 to vertically search down all the rows on sheet 1 for the specific reference number and then bring back the information from one of the cells to the right of it.

This can be very useful.

Click on the help icon. Type in 'vlookup' and press return. Choose 'VLOOKUP function' for more information.

User Avatar

Elenor Tillman

Lvl 10
4y ago

What else can I help you with?

Related Questions

Is vlookup present in Excel 2007?

Yes, VLOOKUP is still in Excel 2007 and 2010.


What software is vlookup commonly used?

VLookup is commonly used in Excel.


Which excel formula mostly use for MIS?

vlookup


What are the3 lookup functions in excel 2007?

LOOKUP, HLOOKUP and VLOOKUP.


Where can one find a tutorial on how to use the Exel VLOOKUP?

Tutorials on how to use the Excel VLOOKUP can be found on Spreadsheet Functions, Launch Excel, Time Atlas, Five Minute Lessons, Corality and Home and Learn.


What is v - look up?

VLOOKUP is a function of Microsoft Excel. You can use VLOOKUP to find a value in a table or list on an Excel sheet. It looks at a value in a column and finds the corresponding value in another column in the same row.


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


Do you have experience in Excel such as VLOOKUP and other more advanced features?

This is a question that could be asked at an interview. To answer yes, you would need to have a good knowledge of Excel. There are a lot of specialised functions, such as VLOOKUP, that more advanced users can work with. For a job that has a lot of Excel involved it would be a good idea to look at the more advanced features, such a VLOOKUP and many other functions that a lot of ordinary users know little about. Excel has hundreds of functions and most people only know a small amount of them.


Is the uplookvert function used when the table direction is vertical or up?

Excel does not have an UPLOKVERT function. You might be thinking of VLOOKUP. You use VLOOKUP when your comparison values are located in a column to the left of the data that you want to find.


Where can you get a list of Microsoft Excel column formulas?

There are no column formulas in Excel. Only formulas you put in individual cells. The closest thing to a column formula would be VLOOKUP.


How can you put vlookup formula from three different excel sheet?

When writing the function, in the table array choose the table from the relevant sheet.


What is the excel formula to copy data from one sheet to another when value matches?

Use vlookup function. Follow the link below to see how.