Looking for help with formula.

I have two lists (please refers to the attched image) and I would like to achieve the following, but have no idea on how to go about doing it. Any help is greatly appreciated. Thanks!   Examples: ...