Thank you very much: @JB-007, @z.. & @Spectral Instance; I truly appreciate your attention to this issue. For brevity, I ended up using the formula: =CONCAT(IF(ISNUMBER(SEARCH(C$1:C$11,A1)),D$1:D$11,"")) and it worked on my work laptop (M365) and also worked (briefly) on my home laptop (Microsoft Student Office 2019), but when I moved my reference table, Cols C & D, to their own worksheet (Sheet2!) is where I ran into problems.

1. Like I said it worked as long as all the content stayed in the same worksheet, except Excel put brackets ({}) around my formula: enter image description here
2. I moved my small example table to its own worksheet, Sheet2: enter image description here
3. When I ran my updated formula, I got no value at all in the cell. Then when I clicked on the Formula Wizard, Excel completely crashed and shut down. enter image description here

I am assuming these issues are probably all linked to the destination version of Excel I'm using, but I'd rather hear from you. Thank you once again for your help!