+ Reply to Thread
Results 1 to 3 of 3

Curly bracket and Index function

  1. #1
    Registered User
    Join Date
    07-29-2018
    Location
    Manila, Philippines
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    2

    Red face Curly bracket and Index function

    every time I'm using the index function, some instances that the value becomes error but most of the time it function very well ...
    then I saw some index formula from the internet that they put curly bracket for the index function ...

    guys, can I ask if curly bracket is necessary to use in index function or formula itself ? thanks for response .....

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,630

    Re: Curly bracket and Index function

    Depends what the formula is and how INDEX is being used. If it has curly brackets, it is an array formula. You use Ctrl-Shift-Enter to commit an array formula rather than just using the Enter key.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,630

    Re: Curly bracket and Index function

    Is this resolved or do you need more help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can the large bracket {} be used in the SUMPRODUCT function?
    By alice2011 in forum Excel General
    Replies: 8
    Last Post: 01-31-2015, 08:45 PM
  2. Replies: 2
    Last Post: 07-18-2014, 03:00 AM
  3. curly braces
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2014, 12:48 AM
  4. fill function with number in bracket
    By david90 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-24-2013, 11:32 AM
  5. Cell function inputs based on tax bracket
    By Icarus69 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2011, 11:10 PM
  6. Remove String Within the Bracket and also the Bracket
    By seanyeap in forum Excel General
    Replies: 6
    Last Post: 04-23-2010, 10:24 AM
  7. Expand curly bracket symbol over multicells
    By Hal Plimpton in forum Excel General
    Replies: 4
    Last Post: 12-19-2005, 11:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1