Esculate cost between to dates based on listed Esc Factors

[gheyman]

I am in need of a Dynamic formula that will be able to only us the factors for the years that fall between two identified dates. I Attached a spreadsheet to help explain. I appreciate all the help and guidance.

 

[Tetra201]

Try pasting the following formula in cell F2 and drag-copying it down as needed:

=ROUND(PRODUCT(B2,INDEX(G2:O2,MATCH(YEAR(C2)+1,G$1:O$1,0)):INDEX(G2:O2,MATCH(D2,G$1:O$1,0))),2)

 

[gheyman]

I got an #N/A

 

[gheyman]

Tetra201 I appreciate you helping, did yours work?

 

[Tetra201]

Yes, the formula has been tested to work and to return the expected results on the dataset shown in Post # 1.

 

[gheyman]

interesting. I get the #NA

 

[gheyman]

Maybe formatting?

 

[gheyman]

 

[Tetra201]

Try making sure years in D2:D4 and in G1:O1 are numbers, not text strings (e.g., =ISNUMBER(D2) should return TRUE).