Sorting / Matching two columns

OK, I attached the excel file.

excel_ex.PNG

Here are 3 columns.

The green column is the lookup I want to get the matched "id lookup" numbers from the "id index" which is the area I want search into.

And then get them matched to copy the required emails.

"id index": is the whole department IDs with emails which is +340 members
"id lookup": groups of "id index" which is normally from 10 - 30 members

I want to lookup and match "id lookup" to "id index" and sort them too at the same time.
Of course "emails" would be sorted with the "id index" matches.

Wow, it's like working while looking in a mirror or playing left-handed. :-)

You did not show what the result would look like if it worked as you wanted. Are you looking for a VBA (Macro) answer or are you looking for a formula answer or manual data manipulation answer (using Excel tools - sorting/filtering, etc.)?

What I don't get either is that in your sample file, NONE of the IDs match the index list. Aren't they supposed to?

Oh .. wait a minute. I did a terrible mistake.

I copied the wrong id lookups ! They turned out to be phone numbers and not academic numbers.

What I want is the related emails for a given group numbers of id lookup and get the "match email"

excel_ex1.png

So there will always be just one match per ID? I would think you could just use the Index/Match formula. In D3 enter:
=INDEX($A$3:$A$342,MATCH(C3,$B$3:$B$342,0))

Does that give you what you want?

Yep !

Thank you so much man

You're welcome. Glad I could help.