CrimeDog, I get a #ref error with that one.

=Indirect("Gantt!B"&ROWS($A$1:A1)*$C$1) is getting me the output I need.
thanks very much