Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookups array function by Alan Beban
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookups array function by Alan Beban | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Can I count in an array based on a function? | Excel Worksheet Functions | |||
Array Functions from Alan Beban | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |