Re: $$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

2012-06-09 Thread Dilip Pandey
You are welcome Mr. Gandhi.. And I liked the thought you shared :) It is on a similar line as Chanakya quotes :_ "A person should not be too honest. Straight trees are cut first and honest people are screwed first." ;) Regards, DILIPandey On 6/9/12, Amit Gandhi wrote: > thanks Mr Pandey > >

Re: $$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

2012-06-09 Thread Amit Gandhi
thanks Mr Pandey On Sat, Jun 9, 2012 at 3:03 PM, Dilip Pandey wrote: > Hi Amit, > > See the attached file where I have used Index & Match function in > combination with Row n Arrays to achieve the desired result. Thanks. > > Regards, > DILIPandey > > On 6/9/12, Amit Gandhi wrote: > > Hi Expert

Re: $$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

2012-06-09 Thread Dilip Pandey
Hi Amit, See the attached file where I have used Index & Match function in combination with Row n Arrays to achieve the desired result. Thanks. Regards, DILIPandey On 6/9/12, Amit Gandhi wrote: > Hi Experts > > I want to Lookup PO No. from Lookup data and return all results if there > are mult

$$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

2012-06-09 Thread Amit Gandhi
Hi Experts I want to Lookup PO No. from Lookup data and return all results if there are multiple occurrences. How it will be possible? Pls help me here. Regards Amit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl