Once you select "Oil change" from the drop-down, the price should appear automatically. In the "Unit Price" column, use this formula: =IFERROR(VLOOKUP(C18, Catalog!$A$2:$B$100, 2, FALSE), "") Now, when you choose a service, the price auto-populates.
If you have a separate sheet for your parts inventory, use these functions to auto-fill part names and prices by just typing the part code. Print Area Optimization: Page Layout model deviz service auto excel
👇 Download my custom Excel Auto Service Template [Insert Link] and streamline your business today! Excel Automated Invoice Template - My Online Training Hub Once you select "Oil change" from the drop-down,