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