Before y'all tell me to search please look at the formulas. I have searched and tried all variations mentioned in the docs. The spreadsheet is dead simple. I am trying to populate the driver name cell based on previously recorded license plates. Why is this not working as the docs show? The result with in B11 should be 'Billy Goats'.

Formula with no final value specified (should default to TRUE).

Formula final value sorted set to TRUE, still not working.

Formula final value sorted set to FALSE, still not working.

I am not looking for someone to fix my problem. I just want to know why this is not functioning according to the docs. I am trying to learn, not get free scripting services.

CodePudding user response：

use:

=VLOOKUP(F11, {E1:E10, B1:B10}, 2, 0)