Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Formulas -> Insert Function -> Lookup and Reference

Lookup Function

Select cell C2 and go to the Formulas tab. Click on Insert Function. From the category list, choose Lookup and Reference. Now, find VLookup at the bottom of the function list.