VLOOKUP in bypassing certain look up values

ambuj33

New Member
Joined
Apr 13, 2018
Messages
4
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.
ABCD
B222C343
C343B#N/A
D54I#N/A
E323J4334
F2342D54
G879E#N/A
H97F2342
I4H97
J4334G879

<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.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

ambuj33

New Member
Joined
Apr 13, 2018
Messages
4
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

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,393
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,021
Messages
5,526,299
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top