Forum Discussion
Structured Reference to Specific Cell in Table
I am trying to reference a specific cell in a table from either a separate cell in the same table or a separate sheet in the same workbook, but not from the same row. For example, using the (slightly...
I think you want to use XLOOKUP or FILTER functions.
C4 for Dan's Sales would be
=XLOOKUP("Dan",Table1[Sales Person],Table1[Sales Amount], "not found")
while averages for East could be
=AVERAGE(FILTER(Table1[Sales Amount], LEFT(Table1[Region],4)="East",0))
C4 for Dan's Sales would be
=XLOOKUP("Dan",Table1[Sales Person],Table1[Sales Amount], "not found")
while averages for East could be
=AVERAGE(FILTER(Table1[Sales Amount], LEFT(Table1[Region],4)="East",0))