27 Tem 2023 ... Using XLOOKUP( ) this can also be accomplished. However using INDEX( ) & MATCH( ). enter image description here. • Formula used in cell J1
How to Index Match Array with between two numbers - Stack Overflow
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.