Creating a Price list from Data Entered Daily

Occasional Visitor

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 pricing with excel. I'm not sure what information I need to have in this post. Just ask and I'll add to the post if needed.

 

Table.png

1 Reply

@Cstrickler 

=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.