IF FUNCTION WITH INDEX AND MATCH TO RETURN MULTIPLE VALUES

Hi team, I'm having trouble with the INDEX AND MATCH Formula. Here's what I'm trying to achieve. On the attached Workbook, I have two sheets. Sheet "Data" has all the information I want the formu...

Test.xlsx12 KB

excel

Excel for web

Formulas and Functions

Riny_van_Eekelen
Oct 06, 2021
lamarsmith You tagged your question with "Excel for Web". Then you can use the FILTER function in conjunction with TEXTJOIN as demonstrated in the attached file. Note that I converted the Data into a structured table (called "tblData"). This makes referencing a lot easier.
Test (1).xlsx14 KB

SergeiBaklan

Diamond Contributor

Oct 06, 2021

lamarsmith

Just in case, PivotTable with DAX measure

Outstanding training:=CALCULATE (
    CONCATENATEX ( tblData, tblData[Training Title], ", " ),
    tblData[Transcript Status] <> "Completed"
)

could work.

Shall work in Excel for web if only data model create in desktop version.

Test (1) (4).xlsx129 KB

lamarsmith

Copper Contributor

Oct 06, 2021

Thanks! This is helpful

SergeiBaklan
Diamond Contributor
Oct 06, 2021
lamarsmith , you are welcome

Forum Discussion

IF FUNCTION WITH INDEX AND MATCH TO RETURN MULTIPLE VALUES

Resources