I am currently working on migrating a WorkBook over from Google Sheets to Excel (Sheets is just too slow atm). As expected, there were some syntax changes that had to be made, but I was under the impression that I would be able to perform all the same functions in Excel as in Sheets. I have run into an issue of not being able to pass in multiple filters to a column, as I did in Sheets.
Here is my formula as used in Sheets:
The output of this formula is a spill array that populates the column as each criteria is met, dynamically. The closest I've been able to get in Excel so far is dynamically adding ALL passing criteria into single cells. So, in Sheets where each cell would contain a job number, the job name, and the type of job, Excel would have that information for each job type all in one cell, and populate the column with cells like that.
Does anyone have any advice for this? Is what I'm attempting even possible?
Screenshots for further reference:
Sheets (Correct Format)
Sheets Screenshot.png
Excel (Incorrect Format)
Excel Screenshot.png
Bookmarks