Return just one criteria, ignore others

[Shruder]

Hello,

1. Here is what I need help with. In cell (C5) on Sheet2 I want it to return the Acct # from column A on Sheet1. I have a formula in there now to do that, however it is not picking up the right acct #'s.

2. In Sheet 2, column B I want it to auto fill with the condition of whenever there is a "Yes" in any cell in column C of Sheet1, then give me that result in Column A of Sheet2. I am currently using this formula and it works

=LET(result,Sheet1!C2:C100000,FILTER(result,OFFSET(result,,,,1)<>""))

workbook attached, thanks!

[Fluff13]

Is this what you want

=FILTER(Sheet1!A2:A100000,Sheet1!C2:C100000<>"")

[Shruder]

Yes, that works! Thx

[Fluff13]

You're welcome & thanks for the feedback.