At 13:22 02/10/2009 -0600, Walter Hildebrandt wrote:
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
Er, not quite right! You were recommended to use Ctrl+C - which is
the keyboard shortcut for copying the currently selected cell. You
could then use Ctrl+V, as suggested, to paste (modified) copies into
other cells in your results column. The "C" here is for "copy", of
course - nothing to do with the results column in the example being
column C. You seem to have thought that since your actual results
column is LF, you should modify this keystroke to "Ctrl+LF". Er, no.
The Find & Replace dialog box appeared.
Well, it would. Ctrl+L,F is Ctrl+L followed by Ctrl+F. First,
Ctrl+L aligns left (but that is the default for text, so you probably
didn't see anything happen), and then Ctrl+F is indeed the shortcut
for Find & Replace.
Various entries were made in the dialog box but none of them
worked. What is being done wrong?
That wasn't part of the suggested technique.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
