VLOOKUP() example in Excel

Step 1: Enter data in sheet1.


Step 2: Enter data in Sheet2


Step 3: Enter the formula as '=VLOOKUP(A2,Sheet2!$A$2:$B$4,2)'


Step 4: Just drag it to other rows.


Cheers!!!

No comments:

Post a Comment