vlookup problem

C

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
 
S

Stefi

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

crapit

I got it
Stefi said:
=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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top