Vlookup Mixed

I am at a loss what to do here... I have tried many things

Vlookup is very confused

It gets the first match (it must convert to numeric)
the second item very confused.

SKU Lookup Item Number
001 001
001-12VDC #N/A
001-24VAC #N/A
001-24VDC #N/A
001C #N/A
001C-12VDC #N/A
001C-24VAC #N/A
001C-24VDC #N/A
001CRS #N/A
001CRS-12VDC #N/A

I am getting a #NA value

=VLOOKUP(A3,Database!A:B,1,FALSE)

Any help our guidance would be greatly appreciated.

Thank you very much. I make the update you suggested. That moved the column.

One of the things I noticed were spaces after my items in teh Vlookup So I needed to create a Trim() This solved everything.

=VLOOKUP(TRIM(A2),Database!A:B,1,FALSE)

Thank you for helping

I am using this now.
=IF(ISNA(VLOOKUP(TEXT(TRIM(A18),"#,###"),Database!A:B,2,0)),VLOOKUP(TRIM(A18),Database!A:B,2,0),VLOOKUP(TEXT(TRIM(A18),"#,###"),Database!A:B,2,0))