You can get a table reference, you just can't refer to columns by name using variables, without the use of INDIRECT or INDEX/MATCH or similar. LET doesn't change the way range referencing or other functions work. Or did I miss your point? Your original formula was basically the equivalent of putting a column name in a cell then trying to use that to refer to a table column - e.g. tblTransactions[A2] - and that won't work with or without LET. If they were going to make LET change the way functions operated, I'd much rather they'd made all the xxxIF(S) functions work with the intermediate arrays you always seem to end up with when using LET, LAMBDA et al!