Forum Discussion
Solved
Referencing cell data based on another cell
Hello, I have data in a table that has different amounts and prices. I would like to reference this data range to pull who has the largest inventory and then list that store's price. So...
SDunning Using SORTBY()
• Formula used in cell E2 using Structured References:
=@SORTBY(Data[Price],Data[Inventory],-1)Or without using Tables:
=@SORTBY(C2:C6,B2:B6,-1)
=index(sort(a2:c6,2,-1),1,3)
Thank you!