=VLOOKUP(A2,B:C,1,FALSE) searches A2 (in your example 1005) in column B which
doesn't contain 1005! Make clear, what do you want to achieve!

Regards,
Stefi


€žcrapit€� ezt Ã*rta:

I'm trying vlookup to extract value from B column using A column data but
all return #N/A



A B C D
1005 red box ware
=VLOOKUP(A2,B:C,1,FALSE) return #N/A
1006 yellow software
=VLOOKUP(A2,B:C,1,FALSE) return #N/A
1004 blue entry
=VLOOKUP(A2,B:C,1,FALSE) return #N/A
1111 green strip
=VLOOKUP(A2,B:C,1,FALSE) return #N/A
1234 white package
=VLOOKUP(A2,B:C,1,FALSE) return #N/A