Home

find cell name in result of a formula in a second sheet

stijnvanhoof
New Contributor

Hi I'm making a dashboard where I import raw data reports from an old fashioned ERP system into different sheets. The dashboard sheet then retrieves and calculates different results and combines these into 1 view on 1 sheet.

To find the top performing customers YTD, the dashboard retrieves it's data in sheet 'sales per klant' using the aggregate function: 

=AGGREGATE(14;6;(('sales per klant'!$H$3:$H$1002)*('sales per klant'!$A$3:$A$1002=$A$6));1).

 

the value returned is correct.  However I also want to have the D cell retrieved that is the same as the result found with this formula so I can also link the customer name in the dashboard.  So ideally I need a formula to determine the location of the cell that is the result of the formula, or another way to get this done.

 

thanks

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies