index match with multiple criteria

Where does the ID appear in Sheet1? I'm not understanding this statement

However, the tricky part is, when we enter the ID, we enter them as a range on Sheet1.

Please clarify with an example. Perhaps even an uploaded spreadsheet with examples would be beneficial.