I would like to make a menu, using EXCEL sheet to create, for example, braised pork $15 per serving, enter the name of the dish inside the front cell, how does the price automatically pop up? Thank you! In Sheet1, column A, enter the name of the only spelling column B, enter the price

In Sheet2, column B, enter the function = VLOOKUP (A1, Sheet1!A:G,2,0)

And then select the cell to copy down, copy as much as you like

As long as you enter the name of the dish in Sheet2, column A, the corresponding price will automatically pop up in column B, the price will automatically pop up. Column B will have the corresponding price pop up automatically.