Results 1 to 5 of 5

Extract a list by looking for criteria in two columns

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2017
    Location
    UK
    MS-Off Ver
    2013
    Posts
    16

    Extract a list by looking for criteria in two columns

    Hi all,

    I need help with this excel files that looks at soccer fixtures in one sheet and extracts all the rows that match the team selected another sheet. I've gone so far as make it look on one column, but I need it to look in the other column as well.

    So the output in Sheet "Extract" should be from rows 2,12,13,28. So the logic should be like this: look in column E, if it's not there, look in column F. If it's not there either, move to the next row. Bear in mind that the criteria is a variable, and I will have multiple extract sheets at the same time, with 3-4 teams. So adding helper columns to the fixtures sheet is ok as long as it is not tied to a specific criteria, in this case soccer team. Can it be done?

    Thank you very much for your help!
    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] Extract all records that match criteria in 2 columns
    By drgkt in forum Excel General
    Replies: 13
    Last Post: 09-10-2016, 02:53 PM
  2. Extract list without duplicates according 3 criteria
    By mmx33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2016, 04:51 AM
  3. Replies: 1
    Last Post: 11-13-2015, 04:07 PM
  4. [SOLVED] Extract a sublist from a list based on criteria(s)
    By hcyeap in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-01-2015, 05:16 PM
  5. [SOLVED] Extract a List of Values Filtered by Criteria
    By mcmahobt in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-16-2014, 09:04 AM
  6. How to extract data with criteria from another sheet and list it.
    By macnabong in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2014, 10:10 PM
  7. How can I extract data from a list that meets certain criteria?
    By fsimek in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2008, 04:20 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