• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Creating Advanced Formulas > Functions That Use or Return Arrays

Functions That Use or Return Arrays

Many of Excel's worksheet functions either require an array argument or return an array result (or both). Table 4.1 lists several of these functions and explains how each one uses arrays. (See Part 2, “Harnessing the Power of Functions,” for explanations of these functions.)

Table 4.1. Some Excel Functions That Use Arrays
Function UsesArray Argument?Returns Array Result?
COLUMN()NoYes, if the argument is a range
COLUMNS()YesNo
GROWTH()YesYes
HLOOKUP()YesNo
INDEX()YesYes
LINEST()NoYes
LOGEST()NoYes
LOOKUP()YesNo
MATCH()YesNo
MDETERM()YesNo
MINVERSE()NoYes
MMULT()NoYes
ROW()NoYes, if the argument is a range
ROWS()YesNo
SUMPRODUCT()YesNo
TRANSPOSE()YesYes
TREND()YesYes
VLOOKUP()YesNo



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint