79565281

Date: 2025-04-09 20:36:30
Score: 2
Natty:
Report link

Simple XLOOKUP and TEXTJOIN wrapped in the MAP function to make it dynamic:

=MAP(A3:A4, LAMBDA(m, TEXTJOIN(CHAR(10),,XLOOKUP(TEXTSPLIT(m," "), A9:A12, B9:B12))))

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: LambdaBam