79643272

Date: 2025-05-29 04:14:00
Score: 1.5
Natty:
Report link

@teylin Please read the Note also on Microsoft site XLOOKUP function. The fourth parameter is implicitely defined (default value), and the formula works in the data structure the OP posted. Otherwise I really like XLOOKUP because more flexible.

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • User mentioned (1): @teylin
  • Single line (0.5):
  • Looks like a comment (1):
  • High reputation (-1):
Posted by: Black cat