I know I can reference the whole result of a FILTER function with cell reference plus #. In this case F40#

Is there a way to reference a particular "cell" in the result of a FILTER function? In this case I want something like F40#(.Cells(2,2))

CodePudding user response：

You can use INDEX

=LET(f,FILTER(Table4,Table4[qty]>10),
INDEX(f,2,2))