Vlookup formula in Excel

How to Apply Vlookup Formula in MS Excel Learn in Simple Hindi video Video Tutorial

Vlookup formula in Excel

 How to Apply Vlookup Formula in MS Excel Learn in Simple Hindi video Video Tutorial

 

VLOOKUP IS BASIC AND MOSTLY USED FORMULA IN MS EXCEL, TO APPLY VLOOKUP IN EXCEL WE NEED TO FIND A COLUMN WHOS VALUES ARE ALSO MATCHES OR SIMILAR TO OTHER EXCEL SHEET/FILE FROM WHICH WE NEED DATA AND THIS COLUMN IN BOTH EXCEL IS CALLED AS REF COLUMN.

FORMAT OF VLOOKUP FORMULA:

=VLOOKUP(REF CELL/COLUMN IN SHEET1/FILE1,REF. CELL/COLUMN IN FILE2 TO DATA COLUMN, NO OF DATA COLUMN FROM REF IN SHEET2/FILE2,0)

To understand please watch below Video, it will explain you in detail about vlookup in hindi with good example.

 

Leave a Comment

Your email address will not be published.