To perform a VLOOKUP in Excel, follow these steps: To find the price of “Banana”: This will return 0.50. Use this formula in your Excel sheet where you want the lookup result to appear.