Column A in the spreadsheet is column LC. Column B in the spreadsheet is column LE. Column C in the spreadsheet is LF.
The following formula was put into cell LF1 =IF(ISNA(VLOOKUP(LC1;$LE$1:$LE$12;1;0));"";VLOOKUP(LC1;$LE$1:$LE$12;1;0)) The same word was in cells LC1 and LE1 and that word appeared in cell LF1 I clicked on cell LF1 to select (highlight) that cell and pressed Ctrl+LF The Find & Replace dialog box appeared. Various entries were made in the dialog box but none of them worked. What is being done wrong? On Fri, Oct 2, 2009 at 11:08 AM, Johnny Rosenberg <[email protected]>wrote: > 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] > >
