Forum Discussion
Cstrickler
Apr 26, 2022Copper Contributor
Creating a Price list from Data Entered Daily
I need help creating a "Price list" with the most current price for every product entered. All I really need to see is the Product and current "Rounded" price. This is how we have figured out prici...
OliverScheurich
Apr 26, 2022Gold Contributor
=INDEX($C$2:$C$25,MATCH(LARGE(IF($B$2:$B$25=E6,$A$2:$A$25),1),$A$2:$A$25,0))You can try this formula with the layout of the attached file. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.