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.