Pivot Table in Excel - An Excellent feature

HLOOKUP in Excel

In Microsoft Excel, 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.

Syntax

The syntax for the HLOOKUP function is:

HLOOKUP( value, table_array, index_number, [not_exact_match] )

value is the value to search for in the first row of the table_array.

table_array is two or more rows of data that is sorted in ascending order.

index_number is the row number in table_array from which the matching value must be returned. The first row is 1.

not_exact_match is optional. It determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the HLOOKUP function will look for the next largest value that is less than value. If this parameter is omitted, HLOOKUP will return an approximate match.

Note

• If index_number is less than 1, the HLOOKUP function will return #VALUE!.
• If index_number is greater than the number of columns in table_array, the HLOOKUP function will return #REF!.
• If you enter FALSE for the not_exact_match parameter and no exact match is found, then the HLOOKUP function will return #N/A.

My Testimonial on Youtube

Hi Students , Good Lecture in Hindi for Pointer Concept

Hi students This Video will show you the demonstration of Pointer Concept

Dear Students

This paper is for your practice different from sample paper pattern and Based on Board Sample Paper Pattern. PRACTICE PAPER FOR Board Exam

BLUE PRINT FOR XII COMPUTER SCIENCE PAPER NEW SCHEME

LATEST C++ SAMPLE PAPER for the YEAR  2013  for CLASS XII importnat with NEW MARKING SCHEME

Information Security Awareness - visit site http://www.infosecawareness.in/

Good PPT on Cyberbullying , Parents must see and visit the link