Vlookups array function by Alan Beban

[Guest]

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.

 

[Bernard Liengme]

For array functions follow these steps:
1) select as many cells as are returned (needed) by the function
2) type the function
3) do not use a simple Enter (or green check mark on Formula Bar) but
complete formula with CTRL+SHIFT+ENTER
best wishes

 

[Guest]

For some reason I have this post twice but thats ok. It helped thanks for the
basic vlookups but still only works with exact data. can't use wild cards or
the concatenate function