Finding multiple matches of a single input across multiple rows and columns

Hi,
I need to find all of the matches for the text in D2 of the 'find' tab in the data table C2:Z290 of the 'Table1' tab. I have been searching various Excel help forums for a couple days, and believe I need to use an array function with the MATCH and/or INDEX functions. So far I cannot get anything to work. Any help would be much appreciated!
Laura

Hi,

I would like a list wherever it is easiest to put (tab 2 or a new tab) to show a concatenation of the Sector and Number of the matches from the first tab. I know from doing a manual search of D2 that the first match is in row 2, so I'd like that output to be Beta1. The highlighting that is in there now is remnants of something dumb that I was doing and I should have taken that out.

I'm actually interested in finding the matches for all of the items in column D on tab 2. I figured it would be sort of a manual process involved in copying an array formula down first to find the matches for D2, then starting over with the formula to find the matches for D3. ? So I would be quite happy to just get this working to get matches for D2.

Thanks again!

Laura

Wow, thank you so much!! It works perfectly.