Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"R Double" <R wrote in message
...
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