VLOOKUP IN EXCEL

Vlookup formula in excel

Create a data in excel

Create a table of vlookup

Go to name column and fill the formula

=VLOOKUP(CELL ADDRESS ROLL NO.LOCK BY F4,ALL TABLE CELL ADDRESS LOCK BY F4,COLUMN NO 2 OF NAME COLUMN)

CTRL +   D DOWN

Change Only Column No

Fill the roll no and enter