Autofill until blank cell is reached

Whoops, my bad. I tried it again and it works. Only problem is that the blank cells in the B column which have no "match" or value in the A column all fill up with 0.

Change your formula to test fro 0 and output "".

--

HTH

RP
(remove nothere from the email address if mailing direct)


"uberathlete" <uberathlete.1xzfvb_1131124803.5556@excelforum-nospam.com>
wrote in message
news:uberathlete.1xzfvb_1131124803.5556@excelforum-nospam.com...
>
> Whoops, my bad. I tried it again and it works. Only problem is that the
> blank cells in the B column which have no "match" or value in the A
> column all fill up with 0.
>
>
> --
> uberathlete
> ------------------------------------------------------------------------
> uberathlete's Profile:
http://www.excelforum.com/member.php...o&userid=28388
> View this thread: http://www.excelforum.com/showthread...hreadid=482220
>