+ Reply to Thread
Results 1 to 5 of 5

Lookup with Column and Row Criteria

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    64

    Lookup with Column and Row Criteria

    I am trying to marry 2 reports - one which shows a list of unprocessed pick-up-in-store orders for a website and the other which shows all store hours for the month. If an order is unprocessed, I need quick reference to the store hours that day (i.e. maybe the store was only open half of the day, maybe it was closed, etc.). Since this is a monthly report, I will need to tell Excel to reference both the store and the date and return the listed hours in the yellow box of the attached.

    Any help would be great - thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,971

    Re: Lookup with Column and Row Criteria

    into D4:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and drag it down as needed.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    09-26-2019
    Location
    London, England
    MS-Off Ver
    MS 2016
    Posts
    2

    Re: Lookup with Column and Row Criteria

    As a general note:

    Lookups where the lookup field is in the first row or first column, you can use H Lookups and V lookups respectively.

    If this is not the case for either, you will need to use the Index and Match function to undertake this - as stated in the answer above.
    Last edited by Glenn Kennedy; 09-26-2019 at 11:12 AM. Reason: Advertising removed.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,840

    Re: Lookup with Column and Row Criteria

    elitech:

    Administrative Note:

    Welcome to the forum.

    Unfortunately your post does not comply with Rule #10 of our Forum RULES:

    Do not put links to commercial sites or services or to competing forums in signatures and posts.

    We do not allow advertising, the promotion of your own commercial ventures or the deliberate promotion of other competing fora here.

    I have removed the link(s) from your signature line.

    You will be banned if you continue to try to advertise in this way.
    Glenn



  5. #5
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    64

    Re: Lookup with Column and Row Criteria

    Thank you so much, KOKOSEK! Your formula works great! I hadn't considered just adding a second match criteria - much appreciated!

+ 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. Replies: 14
    Last Post: 05-16-2019, 06:38 AM
  2. Need lookup formula using BOTH row and column criteria
    By albardit18 in forum Excel General
    Replies: 3
    Last Post: 06-16-2016, 04:37 PM
  3. Replies: 7
    Last Post: 07-26-2015, 04:02 PM
  4. Multi-Criteria Column Lookup
    By nielsen555 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2015, 12:11 PM
  5. Lookup from a different column to return sum value if criteria is met.
    By randypang in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2013, 10:49 AM
  6. [SOLVED] Lookup a value in column 3 of a table if criteria in column 1 and 2 are met
    By shepherdc2814 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 12:06 PM
  7. Replies: 2
    Last Post: 10-17-2011, 07:12 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