Populate multiple select lookup based on matching fields between two tables

[Courtenay_Ricke]

I have two tables with matching fields. (week ending dates) I want new records created in Table A populate in the multiple select lookup field in table B if the weekending dates match. How do I do - I fear the AI has sent me on a whild script chase.

[ellen598]

---

@Courtenay_Ricke wrote:

I have two tables with matching fields. (week ending dates) I want new records created in Table A populate in the multiple select lookup field in table B if the weekending dates match. How do I do - I fear the AI has sent me on a whild script chase.

---

Hello,
To achieve this, you can use a combination of VLOOKUP or INDEX MATCH formulas in Excel. Here's a simplified approach:

VLOOKUP: Use VLOOKUP to match the week ending dates in both tables and pull the required data from Table A to Table B.

INDEX MATCH: This is a more flexible method that allows you to look up values based on multiple criteria.

Best Regards,
Ellen Hogan

[Courtenay_Ricke]

Sorry, I'm not using excel, I'm using airtable. am I missing something?

[TheTimeSavingCo]

Hmm, could you provide some screenshots of Table A and Table B with the relevant fields, with some example data and example output?  Would love to help but don't have enough information!

[Courtenay_Ricke]

here you go!

https://www.loom.com/share/c45438baef264aee9bc408fef0df70c6?sid=cdb48c1b-f513-41c1-96e2-7959d9f8fb86