; *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kanwaljit Singh
> *Sent:* 08 November 2012 7:11
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros
@googlegroups.com
Subject: Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple
values by vlookup
Dear Rajan,
Kindly tell Exactly what changes or modifications you have made to the code !
On Thu, Nov 8, 2012 at 6:31 PM, Rajan_Verma wrote:
You can use this one
Function MLOOKUP
; *If LCase$(KA2(r, c)) = LCase$(LookupVal) Then*
>
> * If NthMatch Then*
>
> * n = n + 1*
>
> *If n = NthMatch Then*
>
> *MLOOKUP = KA1(r, c)*
>
> *Exit Function*
>
> *
Exit Function
End If
Else
MLOOKUP = MLOOKUP & "," & KA1(r, c)
End If
End If
Next
Next
MLOOKUP = Mid$(MLOOKUP, 2)
End Function
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-ma
