Only returning first match from FILTER function?

[diversification]

Hi there, is there a way to have the FILTER function only spit out one value? I was thinking maybe if INDEXed the FILTER function, and then MATCHed with (1,1,0) that would work, but it isn't. The filter function is returning the right values, I just want the first one it returns though, so I can fill it down a column in a table.

 

[jasonb75]

Just INDEX will suffice.

=INDEX(filter formula, 1)

 

[Fluff]

How about

=INDEX(your formula,1)

 

[diversification]

Yep, that worked. I apparently use INDEX with MATCH so much I forgot that it could be used without it lol. Thank you both!

 

[Fluff]

Glad we could help & thanks for the feedback.