Updating a field based on contents on another tab
===

I've built a spreadsheet with multiple tabs.

My 'Source' Tab 1 contains columns 'Id' and 'Name'
My 'Target' Tab 2 contains 'Id'

I'm attempting to iterate through the rows in my Target Tab and read the value of the Id and then search my Source Tab for the Id.  When I find the Id, I want to grab the value in the 'Name' field and add it to a cell on the same line of my Target Tab's Id.

I'm having a hard time working through the logic of iterating through one array and ensuring I find the value in either the Target tab or an array of the Target Tabs contents.  In the Target tab, there may be more than one occurrence of an Id, and I would need to update them all. 

Any suggestions would be welcome! 