Function 03)

03) Add Function ARRAYVLOOKUP to active workbook

This LOOKUP function allows you to return an array of values if the item is found more than once.

You may set an optional boolean telling it to return a unique list of values. You may also set an optional maximum return count. Finally, you may change the default separation character from a comma to some other string.

The function takes 3 required arguments and 3 optional arguments:

=ArrayVLookup ( lookup_value , table_array , column_index_num , unique_list , max_returns , separator)

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc