VLOOKUP in bypassing certain look up values

[ambuj33]

Hello,
I am doing an analysis where I need to pick up value from one column and fill a new column with those values by matching 2 other columns present with similar data. However, when I run vlookup it works for few rows and then starts bypassing values randomly. Need help.[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]222[/TD]
[TD]C[/TD]
[TD]343[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]343[/TD]
[TD]B[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]54[/TD]
[TD]I[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]323[/TD]
[TD]J[/TD]
[TD]4334[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]2342[/TD]
[TD]D[/TD]
[TD]54[/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]879[/TD]
[TD]E[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]97[/TD]
[TD]F[/TD]
[TD]2342[/TD]
[/TR]
[TR]
[TD]I[/TD]
[TD]4[/TD]
[TD]H[/TD]
[TD]97[/TD]
[/TR]
[TR]
[TD]J[/TD]
[TD]4334[/TD]
[TD]G[/TD]
[TD]879[/TD]
[/TR]
</tbody>[/TABLE]

Aim is to fill the column D based upon values in Col B against A.
VLOOK UP I used as
=VLOOKUP(C,A:B,2,False)

Please correct me if I am wrong here,TIA.

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try
D1 copied down
=VLOOKUP(C1,A:B,2,0)

Hope this helps

M.

 

[ambuj33]

It worked. Awesomme. Is it because of False replaced by 0 or something else ? howcome that is different from the one I mentioned.

 

[Marcelo Branco]

You formula has an error (in red)
=VLOOKUP(C,A:B,2,False)

To correct it simply replace C with C1. You can use False or 0 in the last argument.

M.

 

[ambuj33]

Perfect.

Thanks.