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.

[Tyro_abc · Accepted solution]

Hi @kheuer 

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

[kheuer]

Good point @Tyro_abc. I was overthinking this solution. Your idea is solving my problem. Thanks!