Using Excel Functions to return Multiple Values

Nesting Functions like Index, Small, IF, Row & Column when using Excel 2016 and Older. Also Nesting Functions like Textjoin & IF when using Excel 2019 and Newer. Nesting these Functions together to return Multiple Values Office Newb Blog https://www.officenewb.com/post/using-excel-functions-to-return-multiple-values