Index/match return multiple results
I have a sheet to track invoices for projects. There is the possibility to have multiple invoice per project. I would like to use index/match to bring that data into another sheet, but I would like to have a separate row for each invoice number. Currently my index/match will only return the first instance of the invoice number, see cells circled in red below. Is there a way to return consecutive values individually?
Help Article Resources
Check out the Formula Handbook template!