LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

Vlookup,hlookup techniques /formula

milind shrikant deoghare (service/ student ) (1299 Points)

25 November 2015

dear friends

Please help me to how to use vlookup formula and just simple steps for vlookup and hlookup in excel

regards

milind

Reply
Follow
Share

1 Replies

Krishna Nayak (web developer) (78 Points)
Replied 25 November 2015

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

HLOOKUP works just like VLOOKUP, but horizontally rather than vertically. So everything I say about VLOOKUP also applies to HLOOKUP.

Excel’s Best Lookup Method: INDEX-MATCH :

The most powerful and flexible way to look up data in Excel is the INDEX-MATCH method. It relies on two Excel functions:

=INDEX(reference, row_num, column_num)

    reference—a range of cells
    row_num—the row in reference from which to return data.
    column_num—the column in reference from which to return data.

If reference is one row or column, the INDEX function can use this syntax:=INDEX(reference, cell_num)

=MATCH(lookup_value, lookup_array, match_type)

    lookup_value—The value to match in lookup_array.
    lookup_array—A range of cells with data.
    match_type—Specifies how Excel matches the lookup_value with values in the lookup_array. For exact matches, always use 0 for this argument.

Zero Addiction Powder