2009/10/2 Walter Hildebrandt <[email protected]>: > In column A there is a list of words. Anywhere from 10 to 100 rows are > involved in column A. In column B I have an other list of words. Anywhere > from 10 to 100 rows are involved in column B > > How can a list of all the words that appear in both A and B columns appear > in column C? > > For example if the word *Good* appeared in both A and B columns, the word * > Good* would appear in column C. If the word *Bad* appeared only in either > column A or B then *Bad* would not appear in column C > In C1: =IF(ISNA(VLOOKUP(A1;$B$1:$B$12;1;0));"";VLOOKUP(A1;$B$1:$B$12;1;0)) ↓ Highlight C1 → Ctrl+c → Highlight C2:C10000 (or whatever you like in the C column) → Ctrl+v ↓ Done
J.R. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
