However, the advantage is that you no longer need to maintain a table on the worksheet.
The disadvantage is that the array is hard-coded into the formula.
Nonetheless, there are situations where a self-contained lookup formula is handy.
However, two-dimensional tables have a more complex syntax.
Thenuse the shortcut F9to convert the reference to an array constant, and copy to the clipboard.
you could then paste the table into a formula as a constant.
