Vlookup to return all values for a given ID.

[Jonlowery]

[FONT=&quot]I am trying to make a vlookup that can return all email addresses associated with specific internal and external ids. I want to be able to type in the Internal ID and return all email addresses associated with it. IE type in 4 and be given the value in cell F7. I believe its going to involve an array formula that uses INDEX and MATCH but im not sure how to structure it. Any help that can be provided with be greatly appreciated!
[/FONT]
https://imgur.com/a/gNI2OqP

 

[Aladin Akyurek]

Control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX(emailaddresses,SMALL(IF(ids=id,ROW(emailaddresses)-ROW(INDEX(emailaddresses,1,1))+1),ROWS($1:1))),"")