On Nov 16, 1:54 pm, Teethless mama
wrote:
="D"&MATCH(LOOKUP(2,1/(D1:D65535<""),D1:D65535),D1:D65535)

Thanks, but I'm getting incorrect results with that starting at around
row 3,700. I'm using Excel 2007.

First, I changed it to return only the row number, and to look from
row 1 down to the current row:

=MATCH(LOOKUP(2,1/(D$1:D3742<""),D$1:D3742),D$1:D3742,0)

With D3689, D3691, D3693, and D3695 all occupied, it returns 3689 for
row 3691 and all rows below that, no matter what cells in column D
below that are occupied.

Excel bug??


Thanks,

Greg