Find matches from COLUMN 'A' with COLUMN 'B'
Pretty simple, yet hard to remember or easy to forget
=VLOOKUP(B:B;C:C;1;FALSE)
Fill up COLUMN 'C' with the formula, the expected results:
All the matches found from A with B will display 'A' data on 'C'
If it's not found it will display NA (not available) message, which you can easily filter and work with.
Drink a coke while you do this as a reward.
Tuesday, September 29, 2009
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment