Macro to Join First Match

kheuer

Hi community,

I have two datasets, one with customer numbers and the dates they were invoiced, and a second one that shows me the household numbers for the customers. Each customer can belong to multiple households. I want to iterate through the list of invoice dates and join the first household number of the second dataset to the first. Attached is a simplistic sample data set to explain what I am looking for. 

Thanks in advance.

Test macro.xlsx

Tyro_abc

Hi @kheuer 

Are you okay if this can be done without Macro? Is there any specific reason why you want to use macro here?

FirstAddress.yxmd