I have a sheet that is structured like this:
ID Code
234 FAC
1255 JHF
5748 LKM
234 POC
1255 MDM
4885 ESD
8299 FAC

I have another sheet that is structured like this:
Name. ID. Code#1. Code#2. Code #3
Bill. 234

What I'm trying to do is search for ID 234 on the first sheet and return all code(s) found to the second sheet. I've not found a good way to do this using XLOOKUP - I only get the first code (FAC) but can't figure how to get the additional code(s) (ex., POC), either elegantly or with brute force. Suggestions?