while the array form works with larger table-like data ranges. There are also advanced Excel functions like VLOOKUP, HLOOKUP, ...

Next, I want to create an employee report in the blue table. When I enter an employee ID, Excel will automatically tell me the employee's name (using the VLOOKUP function), the total number of ...