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.

A	B	C	D
B	222	C	343
C	343	B	#N/A
D	54	I	#N/A
E	323	J	4334
F	2342	D	54
G	879	E	#N/A
H	97	F	2342
I	4	H	97
J	4334	G	879

<tbody>
</tbody>

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.