Dynamic formula with offset and match Issue please help.

**ebitda_traps** · 02-04-2019, 04:05 PM

I want to populate the data tab with the correct price data from the raw tab using a dynamic offset formula. I am stuck.

**KOKOSEK** · 02-04-2019, 04:15 PM

Try into C4:

Formula:

Please Login or Register  to view this content.

drag it right and down as you need

**ebitda_traps** · 02-04-2019, 04:35 PM

It does not work because the dates on the raw tab are different for each index.

**ebitda_traps** · 02-04-2019, 04:44 PM

Please note that the above formula does not work, because the pricing dates are different for each index in the raw tab.

**KOKOSEK** · 02-04-2019, 04:44 PM

Sorry indeed I've missed that.

**ebitda_traps** · 02-04-2019, 04:47 PM

that's the tricky part I can't figure out.

**KOKOSEK** · 02-04-2019, 05:43 PM

Into C4:

Formula:

Please Login or Register  to view this content.

drag left and down

Przechwytywanie.JPG

I hope that's ok.

**ebitda_traps** · 02-04-2019, 06:44 PM

Beautiful. Thank you kindly.

Re: Dynamic formula with offset and match Issue please help.