Compare MATCH modes and maintained groups
Fill K2:Q7 for the numeric queries J2:J7. K returns the first exact position inside unsorted A2:A7, or No exact. L returns the position of the largest key at or below the query in ascending D2:D7, or No lower. M returns the position of the smallest key at or above the query in descending G2:G7, or No upper. N and O return the maintained text group from E and H at the corresponding approximate position; P returns the exact group from B. Q independently returns the nearest-lower group with VLOOKUP on the ascending D2:E7 policy and must agree with N. Positions are 1-based within the selected six-cell range, not spreadsheet row numbers or matched key values. Use explicit MATCH modes 0,1,-1, INDEX for N:P groups, and explicit approximate VLOOKUP for Q. Exact keys may be unsorted or duplicated and select the first occurrence. Lower keys must be strictly increasing and upper keys strictly decreasing; these two policies are editable independently. Keys and queries are finite stored numbers within ±1,000,000. Group labels are nonempty ASCII text up to 40 characters, including a possible text 0 label. Copy within each output column only.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Fill K2:Q7 for the numeric queries J2:J7. K returns the first exact position inside unsorted A2:A7, or No exact. L returns the position of the largest key at or below the query in ascending D2:D7, or No lower. M returns the position of the smallest key at or above the query in descending G2:G7, or No upper. N and O return the maintained text group from E and H at the corresponding approximate position; P returns the exact group from B. Q independently returns the nearest-lower group with VLOOKUP on the ascending D2:E7 policy and must agree with N. Positions are 1-based within the selected six-cell range, not spreadsheet row numbers or matched key values. Use explicit MATCH modes 0,1,-1, INDEX for N:P groups, and explicit approximate VLOOKUP for Q. Exact keys may be unsorted or duplicated and select the first occurrence. Lower keys must be strictly increasing and upper keys strictly decreasing; these two policies are editable independently. Keys and queries are finite stored numbers within ±1,000,000. Group labels are nonempty ASCII text up to 40 characters, including a possible text 0 label. Copy within each output column only.
No account. No upload. Just try it.