vlookup problem

[crapit]

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

 

[Guest]

=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:

 

[crapit]

I got it

=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: