I want to return the results from a filter function formula into ongoing columns rather than down rows – this is because I have a large list of over a 2000 rows of data that I want to look them up in another table and return all the possible values for one code.  i.e. I have hierachical data that is coded and I want to see the unique codes for a level of code up.  My formula is currently: 

=FILTER(‘ACNY 2024′!L2:L15979,’ACNY 2024′!I2:I15979=’Parish make up’!AX2)

Or can I do an xlookup that returns multiple answers but the number of answers will vary between 1 and 13?  Many thanks

​I want to return the results from a filter function formula into ongoing columns rather than down rows – this is because I have a large list of over a 2000 rows of data that I want to look them up in another table and return all the possible values for one code.  i.e. I have hierachical data that is coded and I want to see the unique codes for a level of code up.  My formula is currently: =FILTER(‘ACNY 2024′!L2:L15979,’ACNY 2024′!I2:I15979=’Parish make up’!AX2) Or can I do an xlookup that returns multiple answers but the number of answers will vary between 1 and 13?  Many thanks   Read More

​