Vlookup with Left function help!

[vlookup7]

Need help with a vlookup and left function. Tried both formulas below but still get NA error.

Column A has :

123456 cellA1
223456 cellA2
445678 cellA3
667898 cellA4

column D has:
223 cellD1


=VLOOKUP(LEFT(D1,3),$A$1:$A$4,1,0)

=VLOOKUP(--LEFT(D1,3),$A$1:$A$4,1,0)

Attached is a sheet to show example

[Jonmo1]

Try this array formula entered with CTRL + SHIFT + ENTER

=INDEX($A$1:$A$4,MATCH(LEFT(D1,3),LEFT($A$1:$A$4,3),0))

[AlKey]

Or this

Please Login or Register  to view this content.

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.