How to use VLOOKUP & HLOOKUP Function in MS Excel
How to use VLOOKUP & HLOOKUP Function in MS Excel
Like FB page HandPicked Songs
VLOOKUP & HLOOKUP functions are mainly used to fetch a specific
data from a bulk of data that we already have.
So in general, We can state like we are going to look for a data we
don't know with a data we already know from the sheet.
VLOOKUP & HLOOKUP function are almost similar. The only difference
is like VLOOKUP search for data which are fed vertically and HLOOKUP
search for data which are fed horizontally.
Watch the video for detailed Explanation: (Click the chapter to directly view that chapter in video)
-------Contents of this Video------
0:00 -
Intro
1:06 -
Explaining VLOOKUP syntax
10:12 -
VLOOKUP with source as table
Comments
Post a Comment