How to retrieve the historical price based on the transaction date

[nicholascky]

Hi everyone,

I�ve created a transaction listing based on three types of materials. However, I need a formula to retrieve the historical average price from the second tab for each material. I would appreciate it if you could help me with the formula.

Thank you!

[Pete_UK]

You can use this formula in H5 for the first metal (Platinum):

=SUMIFS('Tab B - Historial Pricing'!C$4:C$39,'Tab B - Historial Pricing'!$B$4:$B$39,EOMONTH($C5,-1)+1)

Copy/Paste this into J5 and L5 for the other metals, then copy all 3 formulae down as far as required.

Hope this helps.

Pete

[nicholascky]

Thank you Peter! It works!

[Pete_UK]

Glad to help, and thanks for the rep.

Pete