XLOOKUP Into Excel Data Types - 2332

У вашего броузера проблема в совместимости с HTML5

An awesome trick when you are referring to a data type cell in a formula. I learned this from Chandoo - when he was explaining why another formula was *not* working.
Using XLOOKUP (or INDEX/MATCH), if your lookup table contains data types, you can refer to columns that you can’t see in the grid.
I sort of new something related to this in the past - when you can sort a table by a field that is not in the table if the table contains data types.