Re: $$Excel-Macros$$ help on find the list matches to the cell part value

2015-12-22 Thread Ganesh N
Thanks Pankaj and others. It works fine. Thanks a lot pankaj. Im going to apply in my base data if any concern kindly help... Thanks Regards, Ganesh N On Tue, Dec 22, 2015 at 9:37 PM, Pankaj Sharma wrote: > Dear Ganesh, > > I hope it should be ok. > > > Sub

RE: $$Excel-Macros$$ help on find the list matches to the cell part value

2015-12-22 Thread Mihai Ghilea
PFA. METABRAS Mihai Ghilea | Administrator retea T: +4(0) 268.407.410 | F: 0268.407.426 | M: 0728.994.113 A: Strada Grivitei A44, Cod postal RO500182 E: mihai.ghi...@metabras.ro W: 3W.METABRAS.RO

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

2015-12-22 Thread Pankaj Sharma
check it ! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

2015-12-22 Thread Ganesh N
Dear Team, Thanks, But I not get the correct answer. I will say again in the column A I have the list of number. In column E I have some date. I want to check any one in the list (column A) is appearing in column E single cell. If cell E2 have the any number in Column A then i need the answer as

$$Excel-Macros$$ help on find the list matches to the cell part value

2015-12-22 Thread Ganesh N
Dear team, I want to find the any of the given list of value matches (part) in the particular cell using formula or macro. Please find the attached excel. If the solution in formula that would be great!! If you have any concern let me know. Thanks Team, Regards, Ganesh N -- Are you

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

2015-12-22 Thread Pankaj Sharma
Dear Ganesh, I hope it should be ok. Sub lookup_list() Dim wf As Object: Set wf = Application.WorksheetFunction Dim list As Range: Set list = Range("A1", Range("A" & Rows.Count).End(xlUp)) Dim v1 As Long, v2 As Long, r As Long, a As Long, b As Long On Error Resume Next For