79457093

Date: 2025-02-21 10:44:04
Score: 0.5
Natty:
Report link

This is solution for Microsoft 365:

enter image description here

[Sheet1!D2 and fill down]=TOROW(FILTER(Sheet2!$H$4:$H$9;Sheet2!$B$4:$B$9=C2))

Assuming the first picture is Sheet1, the second - Sheet2.

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