Question: how to make a lookup formula in excel?
Answer: Click the cell where you want the VLOOKUP formula to be calculated.
Click "Formula" at the top of the screen.
Click "Lookup & Reference" on the Ribbon.
Click "VLOOKUP" at the bottom of the drop-down menu.
Specify the cell in which you will enter the value whose data you're looking for.