indexcol

The data is in the form: 1 a 1 b 1 c 2 d 3 e 1 f 2 g 3 h 2 i For grouping all the values against unique entries, a,b,c,f in front of 1, d,g,i, in front of i and so on, i have following VBA code: Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long) Dim r As Range Dim...

Here is the code I am using to do a Custom vlookup. It puts spaces in between the results. I need line breaks instead. Function CusVlookup(lookupval, lookuprange As Range, indexcol As Long) 'updateby Extendoffice 20151118 Dim x As Range Dim result As String result = "" For Each x In lookuprange...

I found some code to use vlookup and concatenate data that has multiple matching values. It works great, but I need it to put in a line break after each result instead of a space. Any help is appreciated. Function CusVlookup(lookupval, lookuprange As Range, indexcol As Long) 'updateby...