Results 1 to 9 of 9

Formula to pull info from different tabs based on criteria

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    Georgia, United States
    MS-Off Ver
    MS Office 2013
    Posts
    12

    Formula to pull info from different tabs based on criteria

    Hi.

    I have attached a spreadsheet with an example to help. I need to be able to budget data automatically from different spreadsheets based on a Date in the main sheet. So if the date is 1-Mar-2016, it needs to go to the '2016 final budget' tab and pull data for march. If I change the date to 1-Mar-2017, it needs to pull the march data from the '2017 Final Budget' tab. Is this possible?
    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. [SOLVED] Pull data from a table based on multiple criteria - old formula trying to use AND
    By tweaver in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2016, 04:37 PM
  2. pull over info based on formula.. ?
    By EC37 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-16-2015, 01:59 PM
  3. Replies: 0
    Last Post: 02-05-2014, 05:18 PM
  4. Replies: 4
    Last Post: 10-02-2013, 03:00 PM
  5. Formula to pull rows of data based on a column cell value (Criteria)
    By PaulLor89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2013, 11:26 AM
  6. how to pull info from multiple tabs within same wosksheet?
    By inspirz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2005, 03:46 AM
  7. Replies: 0
    Last Post: 12-07-2005, 02:45 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