Results 1 to 9 of 9

Searching matching vertical and horizontal criteria in multiple sheets

Threaded View

Bloozntooz Searching matching vertical... 04-10-2015, 03:17 PM
p24leclerc Re: Searching matching... 04-10-2015, 04:08 PM
p24leclerc Re: Searching matching... 04-10-2015, 04:21 PM
Bloozntooz Re: Searching matching... 04-11-2015, 09:27 PM
onroute Re: Searching matching... 04-12-2015, 09:03 AM
Bloozntooz Re: Searching matching... 04-13-2015, 01:00 PM
FlameRetired Re: Searching matching... 04-13-2015, 04:29 PM
Bloozntooz Re: Searching matching... 04-14-2015, 03:55 PM
FlameRetired Re: Searching matching... 04-14-2015, 04:12 PM
  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    Bangkok
    MS-Off Ver
    Excel 2013
    Posts
    8

    Searching matching vertical and horizontal criteria in multiple sheets

    From the attached Workbook:

    I need to lookup 2 criteria from the ‘Tracking’ sheet (a name from column B, and a location from Row 2) and search within multiple ‘Month’ sheets (I have only shown 2 but in reality there are 12) to find the name and corresponding location vertically. I then need the ‘Tracking’ sheet cell to return a ‘1’ if the found match has a ‘Result’ column value of either “Early”, “Ontime”, or “Late”, and to be left blank for all other permutations.

    I have tried with VLOOKUP, HLOOKUP, INDEX, MATCH etc but cannot bet anywhere near.

    I guess my complication is search criteria listed both vertically and horizontally and finding a match in sheets in different range of cell ranges.

    I have manually populated the ‘Tracking’ sheet with the expected values that should be returned if a formula works.

    I would prefer a solution using standard Excel functions because others will need to understand this in the future, but VB Code will be acceptable is that is the way forward.

    Thanks a bunch for any 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] Summing Data with Multiple Criteria on Horizontal and Vertical Axis'
    By tlscowden in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2015, 03:11 PM
  2. [SOLVED] Matching multiple criteria in two books, one data is horizontal, the other is vertical.
    By udrmichelle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2015, 04:58 PM
  3. [SOLVED] 3 criteria for horizontal and vertical matching
    By mator in forum Excel General
    Replies: 5
    Last Post: 12-24-2014, 07:19 AM
  4. 3 criteria for horizontal and vertical matching from a table
    By mator in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-24-2014, 06:28 AM
  5. Replies: 5
    Last Post: 06-06-2013, 05:12 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