I am curious about what do your lookup tables look like.
Omar Risk wrote:
PCon-A includes LAD-1 and LAD-2
LAD-2 is also partly in PCon-B
PCon-B includes LAD-2 and LAD-3
Do PCon-A, PCon-B, ..., have intersections?
Do LAD-1, LAD-2,... have intersections?
Thanks for your response. Sorry for my delay.
Parliamentary constituencies do not overlap with each other and local authority districts don't overlap with with each other
I made a sample according to my understanding of your requirements.
May not be correct, but hope to provide some hints for you.
LAD12CDO.xlsx and PCON12CDO.xlsx are the samples I created, which contains values in each.
Please refer to the attached zip file for details.
Data Blending Sample.zip 61.2 KB