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.

Suggestion: add an option to bind a choice-based question to a Dynamic Matrix to populate choices based on Matrix rows. T12779 - Changing number of dropdown options based on matrix rows https://sur ...