Results 1 to 8 of 8

Indexing formula with multiple sheets

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Boulder, Colorado
    MS-Off Ver
    2016
    Posts
    45

    Indexing formula with multiple sheets

    So I'm having an issue pulling data from two sheets that have the same headings into a master sheet where all the data should be kept. The "Initial Invoices" sheet and "Secondary Invoices" are the sheets where the data should be pulled from. I understand how to use an index array formula to pull data from another sheet in excel but I'm having trouble when I need to pull the data from two sheets into one giant sheet which will ultimately contain every invoice.

    Here's the formula I'm attempting and having trouble with...It's clearly wrong as you'll see the results are adding whats being reported for "Table2" to whats being reported in "table3" but its how I imagined the formula should work. Hopefully you'll understand what I'm referring to as you see the sample file.

    =IFERROR(INDEX(Table2+Table3[#Data],SMALL(IF((Table2[PO '#]<>"")+(Table3[PO '#]<>""),ROW(Table2[PO '#])-MIN(ROW(Table2[PO '#]))+1,""),ROWS($1:2)), MATCH(A$1,'Initial Invoices'!$A$1:$D$1,0)),"")

    So as youll see in the "master invoices" sheet, the formula is only reporting 9 rows of data when it should be reporting all 14 distinct PO #'s. (9 from Table2 and 5 from Table3) Instead of adding the two numbers together.

    Thank you in advance for your help
    Mike Stafford
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Indexing and matching cells across two sheets
    By Rebecca Gillon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-27-2013, 11:18 AM
  2. [SOLVED] Multiple indexing arrays?
    By sperrysperry in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-16-2013, 01:16 AM
  3. [SOLVED] Indexing multiple arrays
    By Kybynn in forum Excel General
    Replies: 6
    Last Post: 05-28-2012, 10:32 PM
  4. [SOLVED] Matching and Indexing Multiple Columns
    By tim220225 in forum Excel General
    Replies: 10
    Last Post: 03-29-2012, 07:26 AM
  5. Replies: 4
    Last Post: 12-06-2011, 03:01 PM
  6. Adding multiple match indexing
    By jb2235 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2011, 02:20 AM
  7. Indexing Multiple Tables
    By Haywire79 in forum Excel General
    Replies: 6
    Last Post: 08-13-2010, 02:12 AM
  8. Skip sheets while indexing
    By Melinda Chase in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2006, 03:55 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