VLookup & HLookup Tutorial with Example

Learn Vlookup & Hlookup in simple way with data drop down by Excel Mind

Formula as in video:
VLOOKUP(lookup_value, table_array, col_index_number,range_lookup)
=VLOOKUP(F6,B2:C20,2,FALSE)

HLOOKUP(lookup_value, table_array, row_index_number,range_lookup)
=HLOOKUP(F6,G2:Y3,2,FALSE)

Just change the range as per you requirement.

Excel Mind Blog:
excelmindd.blogspot.com/

Twitter Handle:
twitter.com/Excel_Mind


#excel #vlookup #hlookup #knowledge #excelmind #tutorial #advanceexcel #microsoftexcel #list #datavalidation #msexcel #formula #xlookup #msexcel #msexcelfullcourse #dropdown #lookup