Wow...............!!!!! Thanks Danial for positive reply. That's what I am searching for. Thanks so much.
But one more query, why need to press 'Ctrl+Shift+Enter'? What will happened if I will not press that key-combination? What an array formula? Please assist me, Master. I am waiting for your reply. Thanks & Regards, Dhananjay On 7/23/09, Daniel <dcolarde...@free.fr> wrote: > > Hello. > > > > Have a look at the attached file. Note that the formulas are array > formulas, so that you have to validate them with Ctrl+Shift+Enter. > > > > Daniel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Dhananjay Pinjan > *Sent:* jeudi 23 juillet 2009 13:42 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: please help > > > > Hello Daniel, > > > > Sorry for your inconveince with the file provided me. > > I am sending the 'repaired' file for your information. > > > > Thanks for reply. > > > > > > On 7/19/09, *Daniel* <dcolarde...@free.fr> wrote: > > Hello. > > > > “THESE ALL ARE SAME VALUES WITH "VLOOKUP" FORMULA & I WANT IT VARIED LIKE > "H" COLUMN” > > H columns are empty… > > Concerning G5 you indicate the formula in D5 : > > “VLOOKUP(D5,Yard!A:C,3,FALSE)” > > But what’s in D5 ? > > Can you precise, please ? > > > > Regards. > > > > Daniel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Dhananjay Pinjan > *Sent:* samedi 18 juillet 2009 22:16 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ please help > > > > Hi, > > I attached herewith one Excel file & I want solution on it. (questions are > on sheet). > > > > Please Help. > > > > Thanks in advance > > > > Regards, > > Dhananjay Pinjan > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---