2009/10/2 Walter Hildebrandt <[email protected]>: > 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
Yes, wasn't that what you were asking for? What this formula do, is to display the value in LC if the same value can be found somewhere in LE1:LE12. By the way, I only tested the formula on a small area, as you can see the 12 first rows. If you want it to work on, let's say the 10000 first rows, then the $LE$12 should be replaced by $LE$10000. Or $LE$65536 for the whole column. Maybe I misunderstood the original question, I don't know. Here's what could happen in an example (the formula above is autofilled to LF): LC LE LF this how this is do a you a little feel test a test I morning hope like it this feels test feels relevant feels Now it's easy to see that ”this”, ”a”, ”test” and ”feels” exists in both the LC and LE columns. Wasn't this what you asked for? J.R. > > 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] >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
