D
Dick Minter
The IF function may be used to place a blank value in a
cell based on a criteria.
Example: =if(iserror(vlookup(a1,table,2,false)),"",vlookup
(a1,table,2))
The "" value, however, is not a true blank or null. Is it
possible to use IF to place a null, or simply leave a cell
unchanged?
Second question:
Assume a range A1:C25 in which A1:B25 and cell C1 are
populated. In Lotus 123, if I wanted to copy a formula in
C1 to C2:C25, I would move the cursor to C2 and anchor,
move to B1 and use key stokes {End} {Down} to move
instantly to B25, move the cursor one cell right to C25,
thus quickly selecting C2:C25 without having to page or
cursor or drag to select the range I want. This is
functionality is particularly helpful in macros when you
want to redefine a range to those rows holding records.
Excel appears to not work this way, moving instead to the
last row in the anchor column when {End}{Down}is pressed,
usually the end of the spreadsheet. Is there a way in
Excel to emulate the 123 functionality, particularly in
Excel macros?
cell based on a criteria.
Example: =if(iserror(vlookup(a1,table,2,false)),"",vlookup
(a1,table,2))
The "" value, however, is not a true blank or null. Is it
possible to use IF to place a null, or simply leave a cell
unchanged?
Second question:
Assume a range A1:C25 in which A1:B25 and cell C1 are
populated. In Lotus 123, if I wanted to copy a formula in
C1 to C2:C25, I would move the cursor to C2 and anchor,
move to B1 and use key stokes {End} {Down} to move
instantly to B25, move the cursor one cell right to C25,
thus quickly selecting C2:C25 without having to page or
cursor or drag to select the range I want. This is
functionality is particularly helpful in macros when you
want to redefine a range to those rows holding records.
Excel appears to not work this way, moving instead to the
last row in the anchor column when {End}{Down}is pressed,
usually the end of the spreadsheet. Is there a way in
Excel to emulate the 123 functionality, particularly in
Excel macros?