How to use V-LOOKUP and H-LOOKUP in MS Excel In Hindi



Today We will Learning about V-Lookup & H-Lookup. It is most useful formula and function in Excel,How Search data & Mapping with Easy Way.How to Use VLOOKUP or HLOOKUP to find an exact match

V-LOOKUP : V-VERTICAL (ROW) & Lookup (Data Search)

H-LOOKUP : H-HORIZONTAL (COLUMN) & Lookup (Data Search)
VLOOKUP Function
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
HLOOKUP Function
=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

Excel Array Power-boost for Excel…

Leave a Reply

Your email address will not be published. Required fields are marked *