Choose function under the filter function isn't working properly

[golffor1]

I am using excel365 online and but have excel2016 downloaded onto my computer. I am getting error messages but not sure why. The formula that I have is as follows:

=FILTER(CHOOSE((1,2,3),'Employee_Name'!A:A,'Employee_Name'!J:J,'Employee_Name'!B:B),'Employee_Name'!G:G="Bob","")

I have changed the sheetnames, but the formula should still be the same. The youtube video's i am watching show this formul as being correct, but for the life of me I am not able to make it work.

This has to be done online, and I know filter function works...but for the life of me I can't figure out why this isn't working.

 

[Joe4]

The FILTER function is not available in Excel 2016.

 

[Fluff]

The 123 should be in {} not () but you could also use

=FILTER(hstack('Employee_Name'!A:A,'Employee_Name'!J:J,'Employee_Name'!B:B),'Employee_Name'!G:G="Bob","")