Vlookup and Hlookup in excel

                                 

                                   Vlookup process

1)open excel 

2) follow second process

3) type a vlookup formula in B2 cell.

LOOKUP VALUE =A2

TABLE ARRAY= $E$4:$G$7

COLUMN=3 

EXACT VALUE =false

Question- What is v lookup?

Answer- V lookup is full form vertical lookup. It is a function that makes excel search for a certain in column.

Note point: - vlookup formula is every value required in proper place means  =vlookup({lookup value}, {table array},{column},{false}).

                               Hlookup process

1)open excel 

2) follow second process

3) type a v lookup formula in b2 cell.

LOOKUP VALUE =A2

TABLE ARRAY= $F$3:$I$5

COLUMN=3 

EXACT VALUE =false

Question- What is hlookup?

Answer- V lookup is full form horizontal lookup. It is a function that makes excel search for a certain in row.

Note point: - hlookup formula is every value required in proper place means  =hlookup({lookup value}, {table array},{row},{false}).

Vlookup and hlookup is very important part of excel. If you don't know the Vlookup and hlookup so you don't know the excel.

Note point:- vlookup and hookup is function.
=Vlookup()
=Hookup()
Every function started to first equal sign after function then bracket.

This vedio has full information about vlookup and hlookup please check. And also giving the you tube link
 https://youtu.be/FwvnCdwZE2w