The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms ...

Finally, I can select the return array, which is cells C2 to C9 ... instead of direct references when dealing with tables in Excel. First, structured references are easier to create and read ...