Fill Series

  • Thread starter Thread starter Nathan Bell
  • Start date Start date
N

Nathan Bell

All,

I am trying to fill a series in a row to the right. Upon doing this
excel moves the value of each cell up only 1 column. I want it to move up
2 columns. For example here is the starting folrmula:

=IF(ISNA(VLOOKUP(B3,NPIData!$A$4:NPIData!$B$82,2,0)),"",VLOOKUP(B3,NPIData!$
A$4:NPIData!$B$82,2,0))

but every time I do a fill series I get the following:

=IF(ISNA(VLOOKUP(B3,NPIData!$B$4:NPIData!$C$82,2,0)),"",VLOOKUP(B3,NPIData!$
B$4:NPIData!$C$82,2,0))

and I would like when I do a fill series for the next formula to result in
:

=IF(ISNA(VLOOKUP(B3,NPIData!$C$4:NPIData!$D$82,2,0)),"",VLOOKUP(B3,NPIData!$
C$4:NPIData!$D$82,2,0))

Basically I want the automatic excel step function to go up by 2 columns
instead of 1 when doing a fill series. Any help would be greatly
appreciated.

Regards,

Nathan
 
Let me specify as well, I am trying to fill a series in a row to the
right. Upon doing this excel moves the value of each cell up only 1
column. I want it to move up 2 columns (when only moving 1 cell to the
right).
 
Excel doesnt always handle this series filling very well when using
ISERROR - you may want to try referencing a cell in each column for the
formula
 
"Nathan Bell"
Let me specify as well, I am trying to fill a series in a row to the
right. Upon doing this excel moves the value of each cell up only 1
column. I want it to move up 2 columns (when only moving 1 cell to the
right).
Click to expand...


May can insert a row(1:1) as Series numbers.
using function offset($A$1,0,A$1*2,1,1) locate those cell.
 
Back
Top