+ Reply to Thread
Results 1 to 10 of 10

Horizontal and vertical criteria ranges + vlookup multiple conditions?

Hybrid View

  1. #1
    Registered User
    Join Date
    07-14-2017
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    6

    Re: Horizontal and vertical criteria ranges + vlookup multiple conditions?

    Something like this:
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Horizontal and vertical criteria ranges + vlookup multiple conditions?

    Quote Originally Posted by lukasvjohansson View Post
    Something like this:
    Sorry for off-topic interjection:

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-14-2017
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    6
    Quote Originally Posted by FDibbins View Post
    Sorry for off-topic interjection:

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!
    Great feedback, I was in a hurry. I will keep that in mind. Thank you!

+ 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. solved
    By ravidesai in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2016, 10:55 AM
  2. Sum with multiple criteria Horizontal and Vertical
    By freqzz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2015, 04:39 AM
  3. Sum Multiple Criteria horizontal and vertical
    By baronk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-16-2015, 07:55 AM
  4. Replies: 3
    Last Post: 06-12-2015, 10:33 AM
  5. Searching matching vertical and horizontal criteria in multiple sheets
    By Bloozntooz in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-14-2015, 04:12 PM
  6. [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
  7. [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

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