Thread: vlookup problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crapit[_2_] crapit[_2_] is offline
external usenet poster
 
Posts: 18
Default vlookup problem

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