27 Tem 2023 ... Using XLOOKUP( ) this can also be accomplished. However using INDEX( ) & MATCH( ). enter image description here. • Formula used in cell J1