This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a list of names in column A with no repetitions. In column B I have a list of store numbers with multiple repetitions, usually 7-8 names per store number. On another worksheet I have a list of the stores I'd like to reference, as I don't want all of the stores or names to feed into my report. I'd like to create a formula that says look for these particular store numbers and give me all the names associated with the store numbers. Any suggestions?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I think your query should be resolved by my reply of April 12 - refer above reply / image.