Return the first, second, third or nth cell that meets given criteria with a "simple" array formula...The instruction in this sample will show you which functions you'll need and illustrate how they all work together In Excel, how can I copy multiple cells from column B, if matching cells in column C have specific text? on Quora