Using SCROLL and WHICH Functions Together

An Excel file that teaches how to perform Using SCROLL and WHICH Functions Together operation.

Excel Professional Using Scroll and Which Functions Together

The starting reference is set with SHIFT. Position detection is performed with KAÇINCI. Multiple criteria are supported by auxiliary fields. Error conditions are handled gracefully. Flexible ranges can be returned from a single cell.

Hope it is useful.