Notifications
Clear all
Excel Dashboards
3
Posts
2
Users
0
Reactions
88
Views
Topic starter
Hello!
I'm working on a dashboard that requires me to show the price for a retailer, the min price in the market, and the name of the retailer with the min price. I've worked out the first two steps, but am struggling regarding how to return the name of the retailer with the min price. I've tried many different approaches, but am stuck as to how to return the desired result.
Attached is an example of the report I am building.
Would be grateful if anyone can please point me in the right direction?
Many thanks, Danielle
Posted : 26/02/2021 11:23 pm
Hi Danielle,
You can use INDEX & MATCH:
=INDEX('RAW data'!E:E, MATCH(A2&"*"&D2,'RAW data'!C:C&'RAW data'!D:D,0))
Mynda
Posted : 27/02/2021 2:19 am
Topic starter
Thank-you so much!
Posted : 02/03/2021 1:23 am
