Converting a formula from Sheets to Excel

=if(C1="Apple",index('Sheet1'!C2:C), FILTER('Sheet1'!C:C,'Sheet1'!B:B=C1))

Need help converting this please. Little did I know C2:C would be an issue, much less anything else lol.

If C1 on current sheet is Apple, return all of Sheet1 column C, otherwise return only rows of Sheet1 column C that have Sheet1 column B matching current sheet C1

Thanks!