I am using an Index Match formula to pull from a data set and create an invoice for my business. I have assigned a unique invoice # to each set of appointment numbers that belong to the same customer. Invoice #1 is customer #1. Invoice #2 is customer 2 and so on. Invoice #1 has 12 unique visit numbers while invoice # 2 has 1 appointment.
On the face of the invoice I can type in "1" and vlookups pull in the information I need based on the Invoice #. What I need to do on the invoice is populate the appointment numbers and stop populating once the invoice # on the face of the invoice no longer matches the invoice # from my data.
My issue currently is that the Appointment numbers are pulling in even if the Invoice # from the data doesn't match the invoice itself.