Dear Anil, Benefit of Array Function.................
If you've done even a little programming, you've probably run across the term *array*. For our purposes, an array is just a collection of items. In Excel, those items can reside in a single row (called a* one-dimensional horizontal* array), a column (a *one-dimensional vertical* array), or multiple rows and columns (a *two-dimensional *array). You can't create three-dimensional arrays or array formulas in Excel. An *array formula* is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. For example, you can place an array formula in a range of cells and calculate a column or row of subtotals. You can also place a formula in a single cell and calculate a single amount. An array formula that resides in multiple cells is called (logically enough) a *multi-cell* formula, and an array formula that resides in a single cell is called a *single-cell* formula. For more u can click on below given link.. http://www.cpearson.com/excel/ArrayFormulas.aspx http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx On Sun, Aug 28, 2011 at 9:17 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Also I wanted understand, the benefit of Array in excel.**** > > ** ** > > Based on your example, I got the idea on how to use this??? But what if I > use 3 Vlookup or 1 Array is that making significant change or what is the > benefit of it,**** > > ** ** > > The drawback which I could see here of Array is “We can’t change the > formula and we have to delete all the formula and apply it again”**** > > So instead why can’t we use normal formula and change it accordingly as per > our requirement.**** > > ** ** > > Regards, Anil Bhange**** > > IP Phone - 512320 | Mobile - 90290 32123**** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Saturday, August 27, 2011 09:18 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME**** > > ** ** > > Dear Kannan,**** > > **** > > Venkat solution is great but you can use one Vlookup Instead of Three > Vlookup.**** > > **** > > Press ctrl+shift+Enter**** > > **** > > {=VLOOKUP(B2,'Aug 11'!$C:$J,{4,3,8},0)}**** > > See attached sheet...**** > > On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV <venkat1....@gmail.com> wrote:* > *** > > Hi Kannan,**** > > ** ** > > Please provide valid data....Data is not matching with 2Nd sheet**** > > ** ** > > *Best Regards,***** > > *Venkat ***** > > *Chennai***** > > ** ** > > ** ** > > On Sat, Aug 27, 2011 at 4:10 PM, kannan excel <kannan.ex...@gmail.com> > wrote:**** > > Dear Guru,**** > > **** > > **** > > Pls find the attachment and help me. **** > > and i want vloopkup formulas.**** > > **** > > Your's**** > > **** > > kannan.V**** > > Aircel Limited**** > > Chennai**** > > **** > > > > **** > > ** ** > > -- **** > > ** ** > > ** ** > > ** ** > > ** ** > > > > **** > > ** ** > > -- **** > > *Best Regards,***** > > *Venkat ***** > > *Chennai***** > > ** ** > > ** ** > > ** ** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > > -- **** > > Thanks & regards,**** > > Noorain Ansari**** > > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > **** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel