+ Reply to Thread
Results 1 to 1 of 1

Multiple lookup values & multiple criteria.

  1. #1
    Registered User
    Join Date
    11-09-2016
    Location
    London, England
    MS-Off Ver
    2010, 365
    Posts
    6

    Multiple lookup values & multiple criteria.

    Hi All,

    I am having trouble with returning a specific lookup value. Initially I would copy an entry from "System A" sheet column H, (lets use H2 as an example) and paste it into cell B15 (red shaded cell). I'd then manually match the correct value by seeing if the date associated with H2, in J2, falls between the dates (in columns C and D) that are returned by the multiple lookup formula in cells A17:E21. I would then copy the relevant E Number from column B, and paste it in I2.

    However if the works code returns a value of "Workman Feedback Required", then I wish to leave the entry in I2 blank, even if the date criteria matches. These instances would have to be manually investigated. I have highlighted cell H12 as this is an example of that instance.

    The multiple entry lookup is derived from "System B", I added this as I have been copying values from H, and pasting them into B15, as an streamlined method, rather than switching sheets and entering the information into a filter each time.

    I was wondering if there was a formula, or even a macro that could automate this process for me. I have only given a small sample size as the data contains many thousands of rows. If a macro is suggested I am more than happy to split the data into smaller sets and run the macro several times in order to avoid slowing down the system.

    Please feel free to ask for more information if you require.

    Thanks in advance.
    Attached Files Attached Files

+ 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. Finding max values using multiple lookup criteria
    By rcoon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-18-2016, 12:11 PM
  2. Another lookup multiple values with multiple criteria showstopper
    By ykobure in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2015, 01:56 AM
  3. Lookup using multiple criteria- values are in different columns
    By Shareez Saleem in forum Excel General
    Replies: 4
    Last Post: 05-11-2015, 10:18 PM
  4. [SOLVED] Lookup and sum multiple values based on a single criteria in multiple sheets.
    By paulsanett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 12:18 PM
  5. multiple criteria lookup with min max values
    By seanpcorbett1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-21-2013, 01:08 PM
  6. [SOLVED] vba lookup using multiple criteria based no cell values
    By rakeshr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2013, 07:11 AM
  7. Multiple Lookup Values/Criteria
    By BLarche in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2007, 12:20 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