answersLogoWhite

0

VLOOKUP(Lookup Value,Lookup Table,Column Index)

Looks in Lookup Table for a column whose first column contains the Lookup Value and then moves down the column according to Column Index and returns the value of the cell. The values in the first column of Lookup Table can be text, numbers, or logical values. They must be placed in ascending order: 0, 1, 2, ...; A-Z; FALSE, TRUE. If it can't find lookup value, it uses the largest value that is less than the lookup value.

The three parts of it are:

Lookup Value: A value to search for.

Lookup Table: The range of values to search through and return a value from.

Column Index: The number of the column of the value to be returned.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

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.


Is vlookup present in Excel 2007?

Yes, VLOOKUP is still in Excel 2007 and 2010.


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.


What software is vlookup commonly used?

VLookup is commonly used in Excel.


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.


What is unique feature of Microsoft Excel that Microsoft Word cannot accomplished?

it can work stuff out ...


A new feature of Microsoft Office Excel 2007 is?

Ribbons.


What is best feature of Microsoft Excel?

That you can scroll down forever.


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.


Which excel formula mostly use for MIS?

vlookup


What Excel function offers the possibility to view different results depending on the entered condition?

The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.