I need a formula that can find all instances of a record. For example I may
8 different instances where store #805 has an entry. I want to be able to
type in the store number have excel return all eight values from the seperate
entries. So far I have used index(match. But that formula only gives me the
first record in the list. I need to have them all. Any suggestions?