+ Reply to Thread
Results 1 to 2 of 2

Excel 2013 + Help returning text that meets 2 conditions on 2 separate sheets

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Greenville, SC
    MS-Off Ver
    Excel 2016
    Posts
    25

    Excel 2013 + Help returning text that meets 2 conditions on 2 separate sheets

    I have a list of categories on Sheet 1. I need to return an invoice number (text) to Sheet 1 from Sheet 2 which is a database of the general ledger. I need the invoice number returned to only match the invoice that was issued for period (month) that corresponds to a period (month) listed on Sheet 3. There will be numerous lines on Sheet 2 which may reference the same line of business (cookie), but only want the invoice number returned for the period (month) that it corresponds to. Line of business > looks to find the period on the summary sheet (Sheet 3) > returns the invoice number from Sheet 2 for that period.

    Sheet 1
    Lists each line of business (example cookie)

    Sheet 2
    General ledger in columns (invoice numbers contain letters and numbers); there is also a column that corresponds to "cookie" as a reference

    Sheet 3
    Summary page that includes the title of the workbook and reference which period (month) the report is for.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: Excel 2013 + Help returning text that meets 2 conditions on 2 separate sheets

    It would help if you can post a sample file showing expected outcomes.

+ 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. Returning row if conditions met (text)
    By pauldaddyadams in forum Excel General
    Replies: 7
    Last Post: 05-21-2015, 03:32 AM
  2. [SOLVED] Need help returning text if Data meets certain criteria
    By sumner06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2014, 01:06 PM
  3. [SOLVED] Sorting Data that meets criteria to separate spread sheets.
    By john15882 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2014, 01:15 PM
  4. [SOLVED] Changing Cells & Text Color When Formula Meets Certain Conditions
    By VICTOR55 in forum Excel General
    Replies: 3
    Last Post: 12-02-2013, 02:43 AM
  5. [SOLVED] Matching a text reference in separate Excel sheets
    By prssmzk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-24-2012, 04:23 AM
  6. Auto Populating Rows on Separate Sheets with Conditions
    By johnsond1021 in forum Excel General
    Replies: 1
    Last Post: 11-17-2011, 01:58 AM
  7. Referencing cells text output if it meets specific conditions
    By Chersie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2005, 12:06 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