Ticket form

Thank it worked.  I guess I need to review more formulas.  I struggle if you have to use multiple formulas.  Like an xlookup with a nested Xlookup or where you use if, then or in the formula.

Thanks again 

Here you go.

Instead of recreating the informational sheets on 1 page.

The form will be on the first sheet and select information from the 2nd & 3rd sheets on the same file.

I want to create a ticket/invoice where I may have to select information from multiple sheets instead of recreating them.  

QTY has a formula that adds total days, which should multiply by the price once I am able to pull that information from the 3rd page.  I also need the '1" to remain nothing until the date fields are populated for that row.  I am attempting to create rent type ticket.  When a an item number is selected the description is automatically added and the price associated with that item is added as well to complete the formula.  I need to add date picker to the cells for the date cells.

I create a test ticket form.  I have 3 sheets in the file. 

The first sheet contains the ticket form.

The second sheet contains the customer name, address, email, etc.

The third sheet contains the item description and a price.

I was able to add an xlookup to add the customer information.  I attempted to use the same xlookup to bring in the items from the third page.  The xlookup did not work for the items.=XLOOKUP(B19,Table1,2,0)

Please explain in detail how you want to retrieve information from multiple sheets.