Foreach loop lookup between two worksheets

Please post an example workbook using fictional / non confidential data that accuartely represents your real one, showing the existing data and the expected results.

If I'm following your question correctly then I don't see any easy way to do what you want without the use of vba.