A friend comes to you with a broken VLOOKUP. They explain that the code =VLOOKUP("Duer", EmployeeTable, 3) was working perfectly to look up one of the five employees at a snack shop, but that three more people were hired and added to the EmployeeTable and now the VLOOKUP doesn't work for Employee "Duer". It doesn't return an error, but it returns the wrong name. Strangely, the call =VLOOKUP("Alves", EmployeeTable, 3) works perfectly. What is the mostly likely problem?

A friend comes to you with a broken VLOOKUP. They explain that the code =VLOOKUP("Duer", EmployeeTable, 3) was working perfectly to look up one of the five employees at a snack shop, but that three more people were hired and added to the EmployeeTable and now the VLOOKUP doesn't work for Employee "Duer". It doesn't return an error, but it returns the wrong name. Strangely, the call =VLOOKUP("Alves", EmployeeTable, 3) works perfectly. What is the mostly likely problem?

Excel is likely broken and needs to be restarted

Your friend should have switched to an HLOOKUP because the EmployeeTable data table is now longer than it is wide.

The EmployeeTable is no longer in ascending order by last name after the three new employees were added so a range lookup (the default) won't work correctly

There need to be quotes around EmployeeTable for this VLOOKUP to work correctly.