Re: $$Excel-Macros$$ Multiple Values by Vlookup

2012-12-04 Thread >>Excel Beginner<
Hi Noorain Sir, Below mentioned your requirement and find the attachment. =IFERROR(VLOOKUP($I$5,INDIRECT("F"&SMALL(IF($F$5:$F$11=$I$5,ROW($F$5:$F$11)),ROW(A1))&":"&"$G$11"),2,0),"") *Regards,* * * *Excel Beginner* * * On Tue, Dec 4, 2012 at 6:04 PM, NOORAIN ANSARI wrote:

Re: $$Excel-Macros$$ Multiple Values by Vlookup

2012-12-04 Thread NOORAIN ANSARI
ple you can, >> As long as ever you can.” - John Wesley >> *--------- >> >> >> -- >> *From:* NOORAIN ANSARI >> *To:* excel-macros@googlegroups.com >> *Sent:* Tue, December 4, 2012 7:34:36 AM >

Re: $$Excel-Macros$$ Multiple Values by Vlookup

2012-12-04 Thread The Viper
can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* NOORAIN ANSARI > *To:* excel-macros@googlegroups.com > *Sent:* Tue, December 4, 2012 7:34:36 AM > *Subject:* $$Excel-Ma

Re: $$Excel-Macros$$ Multiple Values by Vlookup

2012-12-04 Thread Paul Schreiner
As long as ever you can.” - John Wesley - From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Tue, December 4, 2012 7:34:36 AM Subject: $$Excel-Macros$$ Multiple Values by Vlookup Dear Group, Please find attac

$$Excel-Macros$$ Multiple Values by Vlookup

2012-12-04 Thread NOORAIN ANSARI
Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http:// noorainansari.com http://