Even Rory is still here, it is almost like the old days, but with more Excel gizmos!

Quote Originally Posted by Aflatoon View Post
I don't see that as anything to do with LET though. LET is basically just a formula version of Dim (or indeed Let in M code). The limitation is just a(nother) limitation of tables, as you say. To refer to columns by name, either in LET or any other formula, you need to use INDIRECT or match the name in the headers to get a column number to use in INDEX.
I agree that it is, but LET in Excel had to be built (coded), and if they had thought about it I am sure those guys are plenty smart enough to have catered for a full table reference. You can reference a table in VBA, you can reference a table in M, but not it seems in Excel.