I had down loaded the array functions by Alan Beban. Have them installed as
addins.
When I run the function I get only one line.
Also it will not allow wild cards to be used or to CONCATENATE cells for the
lookup valve.

ID Counts ac {=VLOOKUPs(D1,A2:B14,2)}
ab 845
ac 424
ad 249
ac 231
af 121
ag 87
ac 85
ai 81
aj 72
ak 63
al 60
am 53
an 51

All I get is the first line.

Then once I get this to give mupt lines on my test screen. I will transfer
it to my "data inut" screen where the CONCATENATE comes into play using a
wild card along with it. And the lookup range is on a different sheet which
is updated via another source.