|different value||same value to match||result in one cell|
How to match each row from `different value` with the date from 'same value to match'. If there is a match then in one cell to result text from column 3 'result in one cell'.
For eg. from column 1 date 05/oct/2021 and 29/apr/2022 match with column 2 'same value to match' and the result should be: 'text, text3'. I tried with index and match but show only the first result. Thanks.
Last edited by a moderator: