answersLogoWhite

0

HLOOKUP is a Lookup and Reference function, not a logical function. It is used to search through a table that is arranged horizontally. You would search along a row to find a value, and then move to another row to get a value to return. The corresponding function VLOOKUP is used more often because data is more often arranged in columns rather than rows. See the related question below.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the formula to multiply and add a cell in Excel using hlookup?

The HLOOKUP function searches for value in the top row of table_array and returns the value in the same column based on the index_number. It has nothing to do with multiplying or adding cells, unless you use the results in some kind of calculation. If this does not answer your question, please ask a more specific question. If you want to know about both multiply and add, ask two questions--one for each subject.


Is a look up used in Excel?

Yes. There are 3 main functions for doing lookups. They are LOOKUP, VLOOKUP and HLOOKUP. You can also use a combination of the MATCH and INDEX functions to achieve a lookup.


What is value seek in Excel?

You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.


Which situation use in hlookUP function in excel?

If you want to look up data that has been laid out in a horizontal manner. Vlookup is for vertical data. See the related question below for more information.


Which element points to a logical formula in Excel?

Logical formulas will have some sort of comparison or condition in them. They will result in a TRUE or FALSE value. They will use some of the comparison operators like the greater than symbol and the less than symbol. They may use some of the logical functions, most commonly the IF function, but also others like AND, NOT and OR.


What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.


What is hlookup in Microsoft Excel?

the h stands for horizontal lookup and the v stands for vertical. assume you have two columns and you want to know if there are any names in them that are the same. You can use v look up to tell you how many repeats there are. You can also do that with rows, but you use h lookup. ALso this function can be used to find a certain aspect about a item iin a table.


Which excel formula mostly use for MIS?

vlookup


Can you use a 'wild card' in a formula in Excel?

Yes you can.


Which formula in excel can i use to find the total cost of items?

The "Sum" formula works best.


Is there a shortcut key for fractions?

Not in Excel. Excel does not use fractions. If you need to use fractions, then turn them into decimals. You can represent 1/2 in excel with the formula =1/2.


What is the formula for sound on spreadsheet?

There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.