+ Reply to Thread
Results 1 to 2 of 2

Array formula in a table

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-14-2013
    Location
    Biloxi, Ms
    MS-Off Ver
    2013 or 2016
    Posts
    115

    Array formula in a table

    New question working with tables.

    I have the following formula:
    =iferror(index(Table4[STATUS],Match([BT/AT],IF(Table4[STATUS]<>"INITIAL REJECT",Table4[BT/AT]),0)),"")
    The formula works fine for the first cell, but when I copy it down the column it returns the results from the first cell to all of the cells.

  2. #2
    Forum Contributor
    Join Date
    02-14-2013
    Location
    Biloxi, Ms
    MS-Off Ver
    2013 or 2016
    Posts
    115

    Re: Array formula in a table

    Nevermind, I figured it out. By using a direct input method ti returned the results I was looking for. Here is the formula I used in it's place:

    =IFERROR(INDEX('TR'!N$9:N$1145,MATCH($D10,IF('TR'!N$9:N$1145<>"INITIAL REJECT",'TR'!H$9:H$1145),0)),"")

+ 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. Array Formula to Lookup table.
    By excellearner121 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2014, 07:01 PM
  2. Array formula + Array formula with criteria that lookups a Table
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 11:41 AM
  3. Array Formula in Pivot Table
    By andrewc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-30-2013, 02:50 PM
  4. macro to put zero's in table array - table array will vary in size each time
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2012, 06:12 AM
  5. Formula for table array
    By woody369 in forum Excel General
    Replies: 14
    Last Post: 07-14-2009, 10:00 AM

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