Thanks, can you explain the SPILL array further please. The TEXTJOIN unfortunately won't work for me as I only want 1 value to be returned, I also want it to ignore some other entries e.g. vegetable hence the need to reference values in table A. Updated spreadsheet is attached to add further context.

Example Lookup v2.xlsx