Vlookup doesn't work with column of string

Vote count:

0

I have 4 columns, containing 2 columns of names and 2 columns of values, as below. I need to update Column B with value in K, if the name1 = name2. Both name columns are formatted as text, and values columns are formatted as numeric.

(A) Name1     (B) Value1       (J) Name2     (K) Value2
     A                               A             123    
     B                               B             456   
     C                               X             000   
     D                               Y             000   
     E                               Z             000  
     F                               C             789   

I insterted the following vlookup in the first row of column B, but it returns the name in column A.

=VLOOKUP(A4,J2:J22890,K2:K22890)


I'm expecting to have the following result:
    (A) Name1     (B) Value1       (J) Name2     (K) Value2
         A              123              A             123    
         B              456              X             000   
         C              789              B             456   
         D                               Y             000   
         E                               Z             000  
         F                               C             789   

Am I using vlookup a the wrong way? or is it due to the fact that I'm looking up strings??

asked 38 secs ago

madkitty

290

Vlookup doesn't work with column of string