# How can you use VLOOKUP with a string operator like LEFT() ?

See this example: Vlookup example.ods

If you have a VLOOKUP for a cell (eg =VLOOKUP(A1,C6:D8,2) ) the behaviour is expected. However, if you do =VLOOKUP(LEFT(A2,3),C6:D8,2) and LEFT(A2,3) is the exact same as A1 (4.1 in the example document, VLOOKUP will yield #N/A.

How can you make VLOOKUP work with the LEFT operator?