Power Query Merge - Closest Match

Hi

I have a table where I need to replace values in a field based on the closest match of two other columns.

The attached workbook sets out the solution I am seeking

Allister

Please check the value of E13 (confirm the expected results it should be C instead of B) and try

Formula:

Please Login or Register  to view this content.

I Have updated the workbook
@HansDouwe

Thanks,

I corrected the workbook also in Post #2.
There is also a solution.

Sure, but I'll leave that to the Power Query experts.
I have less experience with that.

So you have said and you will I am sure get one - but you will need to be patient. You should not be bumping a thread after only two hours - 24 hours is OK.

Assuming there is always a prior value for any -1 Key value, you can sort on key then date, then replace the -1 with null, then fill down:

Please Login or Register  to view this content.

Thank You - a nice - non-PQ Solution