Results 1 to 12 of 12

Index and Match Help

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2015
    Location
    Qatar
    MS-Off Ver
    2010
    Posts
    4

    Index and Match Help

    Good day,

    I am having an issue getting a cell to return information from a large database based on two specific criteria.

    I have attached a sample of the problem below.

    What I need to happen is for the Report Tab to search the DB_IFR tab for both the information in column A (Report tab) as well as cell B2 (also in Report Tab).

    What I need the formula to return is the latest date that can be found in column J (Date (Uploaded)) (on the DB_IFR tab).

    The image that I have attached is what I need the final product to look like.

    I have tried my hand at the index and match combination but find myself getting stuck due to me never having used this formula combo.

    ANy help will be greatly appreciated, and thank you!

    Regards,
    PFT
    Attached Images Attached Images
    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] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  2. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. [SOLVED] Index Match from a cell populated from index match
    By MarcLewis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-15-2013, 05:30 AM
  5. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 PM

Tags for this Thread

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