Lookup all matches for multiple lookup values

Hello,

I have a list of multiple values I need to lookup in a corresponding table. I would like to pull all values that match at least one of the values I am looking up. I have attached an example. I am looking up the ASSETNUM and want to return all of the ITEMNUM that match at least one of the ASSETNUM that is being looked up.

Thanks in advance!