Dear ArviLannemets


Tks for your formula.

However, it's not exactly not I am looking for.

As those value can not be using Sumifs since I am not asking to get the sum of the month in total.
Those information can be Zero too as there is actual data which the value is Zero. If the date is not match the formula which should show N/A (erreur message)



As per my message that each month had different BAF value.

I need the value which is based on the period of the month in BAF table & match the date that it's on the Base file.

Those explaination is on those Case 1 to Case 5 in my first message.



On the other hand, the actual database of those column which are not adjacent to each other that why I need to use Helper 1 Column since it might have another column information need to be included in it.



Hope you can help to get the other solution it & tks in advance !


Ale