4+ How To Use Lookup Excel Viral. Open the index formula excel first. Now select cell against number 1 to put the lookup formula to get the result. A beginner's guide to using VLOOKUP KnowTechie from knowtechie.com The xlookup function looks up the last name and returns the id. Notice the return array (c8:e15) includes …