Forum Discussion
Index Match Formula Help
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...
Hi,
For the model like this
you may use formula
=IFERROR(INDEX($C$4:$C$24,AGGREGATE(15,6,1/($B$4:$B$24=E$2)*(ROW($B$4:$B$24)-ROW($B$3)),ROW()-ROW($B$3)+1)),"")
and drag it down till empty rows appear. Please see attached.
Worked like a charm! Thank you
You are welcome
