View Single Post
 
Old 04-23-2019, 05:52 AM
aleman_li aleman_li is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2019
Posts: 2
aleman_li is on a distinguished road
Default

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

Last edited by aleman_li; 04-23-2019 at 12:37 PM.
Reply With Quote