Re: $$Excel-Macros$$ Help with Custom Vlookup

2015-11-06 Thread Paul Schreiner
imes you can, To all the people you can, As long as ever you can.” - John Wesley - From: Mandeep Baluja <rockerna...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Cc: schreiner_p...@att.net; abhishek@gmail.com Sent: Friday, November 6, 20

Re: $$Excel-Macros$$ Help with Custom Vlookup

2015-11-05 Thread Paul Schreiner
ay, November 3, 2015 2:56 AM Subject: $$Excel-Macros$$ Help with Custom Vlookup Hi All, I intend to use this piece of UDF I found on internet for my requirement - Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long)Dim r As RangeDim result As Stringresult = ""For Each

Re: $$Excel-Macros$$ Help with Custom Vlookup

2015-11-05 Thread Abhishek Jain
you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Abhishek Jain <abhishek@gmail.com> > *To:* Paul Schreiner <schreiner_p...@a

Re: $$Excel-Macros$$ Help with Custom Vlookup

2015-11-05 Thread Mandeep Baluja
gt;> >> *“Do all the good you can,By all the means you can,In all the ways you >> can,In all the places you can,At all the times you can,To all the people >> you can,As long as ever you can.” - John Wesley* >> ----------------- >> >> -- >> *From:* Abhishek Jain <abhish.

$$Excel-Macros$$ Help with Custom Vlookup

2015-11-02 Thread Abhishek Jain
Hi All, I intend to use this piece of UDF I found on internet for my requirement - Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long) Dim r As Range Dim result As String result = "" For Each r In lookuprange If r = lookupval Then result = result & " " & r.Offset(0,