https://youtube.com/watch?v=6pSYP2plbdIIn a VLOOKUP formula, you can refer to a lookup table that is in a different Excel workbook. In this example, the price list is in one workbook, and the…