answersLogoWhite

0

VLOOKUP is used to look for a value in a list and return a corresponding value. So you could have a list of products and their prices. When you choose a product, it finds the product in the list and returns the price to you. Some people do not like using VLOOKUP and there can sometimes be issues with it. So the alternative people use is a combination of the INDEX and MATCH functions.

User Avatar

Wiki User

8y ago

What else can I help you with?

Related Questions

Is there any option for a command Vlookup in MS Office?

VLOOKUP has a number of options. It has different arguments. It is also possible to use other methods to do the same task, like the INDEX and MATCH functions.


Can you use vlookup for text?

Yes, VLOOKUP can be used for text or any other kind of data.


What is vlook up table in excel and how it is used?

The VLOOKUP function works on the same principle as HLOOKUP, but instead of searching horizontally, VLOOKUP searches vertically. VLOOKUP searches for a specified value vertically down the first column of an array. When the value is found, VLOOKUP searches across to a specified column and enters the value of the cell. The syntax for the VLOOKUP function follows the same pattern as HLOOKUP, except that instead of specifying a row index number, you would specify a column index number to instruct VLOOKUP to move across to a specific column in the array where the required value is to be found. =VLOOKUP( lookup_value , table_array , col_index_number ) In the case of VLOOKUP, data in the first column of the array should be in ascending order, as VLOOKUP searches down this column for the lookup_value.


What is another word for using the word another?

additional. OR any other OR any more --- OR another OR one more


How can I illuminate my bike wheels without using any batteries?

You can illuminate your bike wheels without using batteries by using reflective tape or stickers that reflect light from streetlights or car headlights. Another option is to use wheel lights that are powered by motion or friction as you ride.


Is there any online job?

There are probably online teaching jobs available. One place to look would be at online universities. Another option is to try tutoring via an online option.


Is there any teaching jobs online ?

There are probably online teaching jobs available. One place to look would be at online universities. Another option is to try tutoring via an online option.


Are there any sites that sell specifically Michele watches?

The MW Official Site can be found at michele.com. Craigslist would be another option if looking for cheap, used watches. EBay would also be a great option.


What is an aerophyte?

An aerophyte is another name for an epiphyte, a plant which grows on another, using it as a physical support, but not obtaining any nutrients from it.


What is another word for corpse?

You could try any of these:dead bodycadavercarcasscarrionthe deceasedremainsand depending on the context of the term you need, pick the appropriate option.


Are there any AC systems for cars only with fresh air and not with recirculating air?

most have the option of using either fresh or recirculated air


What is the formula in Microsoft Excel 2003 to Covert a number to its corresponding word Eg 3 Three?

One way of doing it would be to set up a table with numbers from 0 to 9 in one column and the words from zero to nine in the next column, and then use the Vlookup function.For example: You could put the digits in the cells from C1 to C10 and the words in the cells from D1 to D10. Then in another cell, perhaps D12 put the following formula:=VLOOKUP(C12,C1:D10,2)Then type any digit in cell C12 and the word for that digit would show in D12, where the formula has been typed.