79185636
Date: 2024-11-13 15:45:18
Score: 0.5
Natty:
The required formula is very simple (refers ranges depicted below):
[B2]=XLOOKUP(A2:A18,E2:E5,D2:D5,"",-1)
Generaly, upper range limits (Range 2) are not required.
Reasons:
Posted by: rotabor - Probably link only (1):
- Low length (1):
- Has code block (-0.5):
- High reputation (-1):