Add your new column on your original worksheet that will display the info pulled from the Lookup table. ... Place your cursor in the first blank cell in that column. ... From the Insert menu, select Function…. ... In the Search for a function: text box, type “vlookup” and click Go.