I'm trying to set up a table column in excel to check for matching names between the name columns of both tables, then return the total from the second table.
Currently this works, but I can't sort or filter either table without causing everything to break.
=IF([@Name]=Levels[@Name], Levels[@Total], "---")
I need a way to make this formula work no matter how the tables are sorted and filtered. The reason for the two tables is that the calculations and separate variables for the levels are too lengthy to insert directly into the roster.
I've tried using the row and indirect functions but I can't figure out how to get them to work.
Variable columns are:
Roster[@Name]
Levels[@Name]
Levels[@Total]