dragging formula down makes a copy

[Guest]

I have a formula
=IF(ISERROR((HLOOKUP($F$3,'Sort by
Analyst'!$1:$65536,13,FALSE))),"",(IF((HLOOKUP($F$3,'Sort by
Analyst'!$1:$65536,13,FALSE))=0,"",(HLOOKUP($F$3,'Sort by
Analyst'!$1:$65536,13,FALSE)))))

that I would like to drag down such that the next cell says

=IF(ISERROR((HLOOKUP($F$3,'Sort by
Analyst'!$1:$65536,14,FALSE))),"",(IF((HLOOKUP($F$3,'Sort by
Analyst'!$1:$65536,14,FALSE))=0,"",(HLOOKUP($F$3,'Sort by
Analyst'!$1:$65536,14,FALSE)))))

but it is copying formula rather than increment.

Help

 

[Dave O]

In Excel parlance, the parameters you give inside a formula are called
"arguments". Since that argument is hardcoded into the formula, it
won't change as you copy it down. However, you can replace the 13 with
a cell reference to a cell that contains the number 13- that way when
you copy the formula down that cell reference will change, and you can
change the value in the cell referenced by the second formula to
contain 14.

 

[RagDyer]

Try this:

=IF(ISERROR((HLOOKUP($F$3,'Sort By
Analyst'!$1:$65536,ROWS($1:13),FALSE))),"",(IF((HLOOKUP($F$3,'Sort By
Analyst'!$1:$65536,ROWS($1:13),FALSE))=0,"",(HLOOKUP($F$3,'Sort By
Analyst'!$1:$65536,ROWS($1:13),FALSE)))))