Return Multiple Instances of text

[Wheelie686]

I have a list of names, some of which have an underscore in them and what I would like is another column that extracts only the names with the underscore. As a secondary request, I'd also like to also pull the city said results are from.
Columns E & F show what I'd like the results to pull.

Any help would be appreciated.

[protonLeah]

E2:

Please Login or Register  to view this content.

F2:

Please Login or Register  to view this content.

---

To enter array formulas ensure the cursor is in the formula bar: Simultaneously press Ctrl+Shift+Enter. Excel will automatically enclose the formula in braces "{}".

[Wheelie686]

Thank you protonLeah as usual! Been to the forum before and you've answered my questions in the past

Would there be a way to combine 2 formulas now that I have 2 working for 2 difference sheets? The criteria would still be the same, just looking on both sheets.

Formula 1

Please Login or Register  to view this content.

Formula 2

Please Login or Register  to view this content.

I tried an OR but probably ended up writing it horribly wrong

[protonLeah]

What you have as: INDEX('Comm MTL'!$B$2:'Comm MTL'!$E$500...
is correctly written as: INDEX('Comm MTL'!$B$2:$E$500...

But the original problem involved only two columns: find a name with "_" and return the name and city to another location on the sheet.
The new formula has four columns B - E. So, are the names in column B and the locations in column E?