We know that VLOOKUP is very useful. At the same time, we know that VLOOKUP has its limitations. E.g. VLOOKUP only looks from left to right; VLOOKUP only handle one lookup value. For a simple situation shown below, VLOOKUP doesn’t seem to work (directly).