Forum Discussion
Ticket form
I am creating a test ticket. I attempted to add an xlookup in a cell. This is the formula. =XLOOKUP(B19,Table1,2,0). The ticket I am attempting to create is using information from 2 sheets located...
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)