So far we have learned many formulas using the Lookup function. This tutorial shows how to group the numbers at uneven intervals in Excel by using the Lookup function. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- Use the below formula to group the uneven interval values in Excel.
=LOOKUP(value, intervals,groups)
Syntax Explanations:
- LOOKUP – The LOOKUP Function in Excel performs an approximate match lookup in a one-column or one-row range and returns the corresponding value from another one-column or one-row range
- Value – It represents the criteria value for the input values.
- Intervals – It represents the input data given.
- Groups – It represents the input table value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Refer to the below example image.
- Here, we will give the input values in Column B and Column C.
- Now we are going to group the numbers at uneven intervals based on the given table in Column F and Column G.
- Apply the above-given formula to the formula bar section and press the “Enter” key.
- Finally, it will display the result as per the below image.
Closure:
From this tutorial, you can easily understand the simple formulas used to group the numbers at uneven intervals in Excel. Hope you like this article. Please state your queries in the below comment section. To learn more, check out Geek Excel *and Excel Formulas *!!
Top comments (0)