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

=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

I got it
"Stefi" wrote in message
...
=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