[Tutor] Help with Excel Workbook and URLs, in Python Charm

[Jonathan Torres-Herrera]

Hi Tutors,

Here's my dilemma.

I have a couple of excel workbooks, let's call them workbook-A and
workbook-B.

Workbook-A holds a unique identifier, which happens to be a list of email
addresses.

On workbook-B, I have a list of URLs, each URL opens a unique online excel
workbook with information that includes emails as well.

Here is what I'm asking for help with.

What would be the best approach to have python take each email address on
workbook-A, and look it up against the list of URLs in workbook-B, and then
return which URL it found it on in workbook-A (on a blank column)?