I have two Excel workbooks: one lists broker names, the other holds those same full names paired with their email addresses. The names sit in the same column position in both sheets, so the task is straightforward—I need a clean, formula-driven way to pull each email into the first sheet. Any broker that does not find a match should simply return a blank cell; no highlighting or extra tabs. I’m looking for a lightweight yet reliable solution that uses built-in Excel functions (XLOOKUP, VLOOKUP, or INDEX-MATCH—whichever you feel is most robust) so the file stays dynamic if new brokers are added later. Deliverables • Updated Excel file with the matching formula correctly applied down the column • A brief note or comment inside the sheet explaining the formula used and how to refresh it when data changes That’s all that’s needed—quick, accurate, and reusable.