Results 1 to 8 of 8

Retrieving Data Based on Two Criteria and Two Worksheets

Threaded View

  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

    (I cross posted this in the 2007 Subforum so moderators please feel free to delete the other if necessary, this section seems to generate more traffic) With that said.


    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 from cell "AO24" but also be dynamic.

    Again any help you guys can offer is greatly appreciated.
    Attached Images Attached Images
    Last edited by ERabbit; 08-26-2011 at 06:01 PM.

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