Re: $$Excel-Macros$$ How to Use Vlook with String

2010-08-29 Thread Dilip Pandey
Dear Thakur, I am not sure what you are looking for. Can you elaborate more through a sample file. If you are willing to vlookup the values based on the names, then vlookup will fetch the first value and will ignore the other values which are in bottom. Further to this, I am not sure what are y

Re: $$Excel-Macros$$ How to Use Vlook with String

2010-08-27 Thread prabhakar thakur
Hi All, Do not proper result. due to name is repeated in data than vlookup repeat same all time when ever get same name. sumproduct also calcuate same as vlookup. Thanks, Prabhakar Thakur New Delhi +919953736776 On Fri, Aug 27, 2010 at 6:25 PM, Dilip Pandey wrote: > Hi Pr

Re: $$Excel-Macros$$ How to Use Vlook with String

2010-08-27 Thread Dilip Pandey
Hi Prabhakar, Please provide the sample file for this. Thanks. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Aug 27, 2010 at 12:59 PM, prabhakar thakur < prabhakarthak...@gmail.

$$Excel-Macros$$ How to Use Vlook with String

2010-08-27 Thread prabhakar thakur
Dear All, I have a query for using Vlookup with Array like using Vlookup with Name they have not any unique Data using. Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- Some important l