+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Retrieving Data Based on Two Criteria and Two Worksheets

  1. #1
    Registered User
    Join Date
    08-25-2011
    Location
    So CAl
    MS-Off Ver
    Excel 2007
    Posts
    7

    Retrieving Data Based on Two Criteria and Two Worksheets

    Hi everyone, new here and thanks in advance for any help you can offer.

    What I am trying to do is retrieve data from my second worksheet "Expense" into my first sheet, "Sheet1" only if the account number and date match, if else leave it blank.

    So for example

    I want Data to populate if the account number in Sheet1 Row K25 matches the same account number on my "Expenses" Sheet and only if the same date matches.

    So based on the attached images below I would like Cell "AL25" to populate the data from expenses sheet which would be cell "AO24" but also be dynamic.

    Again any help you guys can offer is greatly appreciated.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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