Practical Excel and spreadsheet guides for data analysis, with tested examples.
Without the fourth argument, VLOOKUP uses approximate match. With the first column out of order, it can return another customer’s name without any error at all. See how to reproduce it, fix it with FALSE and check it.