0
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.
Wiki User
∙ 13y ago
Wiki User
∙ 8y agoThe 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.
=HLookup(value,table_array,index_number,not_exact_match)
Add your answer:
Earn +20 pts
What are the3 lookup functions in excel 2007?
LOOKUP, HLOOKUP and VLOOKUP.
Can a person complete calculations in Microsoft Excel 2003?
Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.
Who are the creators of Microsoft Excel?
Microsoft excel was created by Microsoft
How do you launch Microsoft Excel?
Programs->Microsoft Office->Microsoft Excel
What is the spreadsheet program in Microsoft office 2007?
I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.
Who created Microsoft Excel?
Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.
Is there any hidden game in Excel 2003?
There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.
Different beetwin Microsoft Word Microsoft Excel?
Microsoft Word is used for writing papers, and Microsoft Excel is for spreadsheets.
What is the difference between Microsoft Excel 2003 and Microsoft Word?
Microsoft Excel is a worksheet. Microsoft Word is a word processor.
What computer software use to analyze row and columns of sales figures?
A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.
What is Microsoft Excel used for and what will it allow you to do?
Microsoft Excel allows you to be pretty<3
What is the effectivity of Microsoft Excel through hands on computer?
The effectivity of Microsoft excel?
