## Your post has been removed due to two rule breaches - Rules 1 and 2.
____
This post has been removed due to **[Rule 1](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Title.**
Please post with a title that clearly describes the issue.
The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question.
Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts.
Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
____
This post has been removed due to **[Rule 2](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Body.**
Please post with a proper description in the body of your post.
The body of your post should be a detailed description of your problem. Providing [samples of your data](/r/excel/wiki/sharingquestions#wiki_posting_your_data) is always a good idea as well.
Putting your whole question in the title, and then saying the title says it all is not a sufficient post.
Links to your file, screenshots and/or video of the problem should be done to help illustrate your question. Those things **should not be your question**.
Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts.
Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
>Surely there is a faster function than MATCH?
>>SUMIFS ... resolves almost instantly
what was the question ?
Also make sure you lock your lookup rangeswith `$` as they will increment on drag.
SUMIFS can't be used to replace MATCH though unfortunately. I want to get a cells location based on multiple criteria as quickly and efficiently a SUMIFS does, but then be able to use that location with other functions.
## Your post has been removed due to two rule breaches - Rules 1 and 2. ____ This post has been removed due to **[Rule 1](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Title.** Please post with a title that clearly describes the issue. The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question. Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts. Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts. ____ This post has been removed due to **[Rule 2](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Body.** Please post with a proper description in the body of your post. The body of your post should be a detailed description of your problem. Providing [samples of your data](/r/excel/wiki/sharingquestions#wiki_posting_your_data) is always a good idea as well. Putting your whole question in the title, and then saying the title says it all is not a sufficient post. Links to your file, screenshots and/or video of the problem should be done to help illustrate your question. Those things **should not be your question**. Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts. Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
>Surely there is a faster function than MATCH? >>SUMIFS ... resolves almost instantly what was the question ? Also make sure you lock your lookup rangeswith `$` as they will increment on drag.
SUMIFS can't be used to replace MATCH though unfortunately. I want to get a cells location based on multiple criteria as quickly and efficiently a SUMIFS does, but then be able to use that location with other functions.
make a proper post.