However, when encountering the following problem, VLOOKUP becomes useless. The table below records employee information ... If we are querying the corresponding name using the Employee ID, we can ...