What is the advantage of using zero-length arrays in C? This question was originally answered on Quora by Robert Love.

The array format for analyzing peptide and protein function offers an attractive experimental alternative to traditional library screens. Powerful new approaches have recently been described ...

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.