Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    

HLOOKUP (Horizontal Lookup)

 


HLOOKUP (Horizontal Lookup) is a function in Excel that searches for a value in the top row of a table or range and returns a value in the same column from a row you specify.

Syntax:

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

  • lookup_value: The value you want to search for in the first row of the table.
  • table_array: The range of cells that contains the data.
  • row_index_num: The row number in the table from which to return the value. The top row is row 1.
  • [range_lookup]: Optional. TRUE for an approximate match or FALSE for an exact match (default is TRUE).

Example:

Consider this table:

A

B

C

D

Name

John

Sara

Tom

Age

25

30

22

Height

5'9"

5'5"

6'1"

If you want to look up Sara's age, you can use the following formula:

=HLOOKUP("Sara", A1:D3, 2, FALSE)

  • "Sara" is the lookup_value.
  • A1:D3 is the table_array.
  • 2 refers to the row_index_num (Age is in the second row).
  • FALSE ensures we want an exact match.

Result:

The result will be 30, as Sara's age is 30 in the table.

 

Comments

POPULAR POSTS

essential BAsic excel formulas a quick guide

Some important tips to learn MS Word

Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Excel

How to find sum of numbers with units in a range in Excel?

Rearrange columns in excel sheet using a quick trick

TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET