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

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 lookup_list() > Dim wf As Objec

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

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

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

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

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

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 wrote: > Dear team, > > I want to find the any of the gi

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

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 http://www.metabras.c