Results 1 to 6 of 6

Return multiple values from an array

Threaded View

  1. #1
    Registered User
    Join Date
    12-27-2013
    Location
    Southern, NH
    MS-Off Ver
    Excel 2008 mac
    Posts
    6

    Return multiple values from an array

    Hello All. I am new to this forum but have been kind of an excel geek for some time. I am remodeling my home and have put together a budget template that needs help. I have uploaded the file to make things easy to understand. Basically I want to return the values from column F and G on sheet "ledger" to the corresponding account name to column H in sheet "budget". For example, rows 14, 21, and 22 in the "budget" sheet currently correspond to the "fuel" account. I would like those values in column G (or F) to be added and calculated in cell H58 in the "budget" sheet. I hope this makes sense. Thank you!!

    Scott
    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. Array formula to return multiple values based on various (OR) criteria
    By dancing-shadow in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2013, 05:12 AM
  2. [SOLVED] ARRAY Formula to return multiple values
    By Ricardo Mass in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-01-2013, 01:55 PM
  3. Find a value in an array and return multiple values in an adjacent array
    By tonbra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2012, 08:35 PM
  4. Array Lookup, Return/Sum Multiple Values
    By mre2000 in forum Excel General
    Replies: 3
    Last Post: 01-18-2010, 10:45 PM
  5. Formula / array to return multiple values
    By paulmag in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-03-2008, 11:52 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