Hi All,
I am new to excel functions, I have two columns of data A2 and B2.
A2 has 1000 and B2 800 entries
I done a lookup C2:
=VLOOKUP(B2,A:A,1,0)
When I filter on column C to value N/A, the values are not correct i.e. values are returned in column a and column b is blank. When I then do a manual check the values are present in column a and b, seems my I am missing something basic.
My understanding of the way I put the formula, check everything from B2 and see if present in A2 column. If present return value else show as n/a
Please can you advise...
Many Thanks
Bookmarks