Apr 26 2022 12:44 PM
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.
Apr 26 2022 01:06 PM
=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.