Being able to select multiple data from a spreadsheet to produce a second spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1294708%22%20slang%3D%22en-US%22%3EBeing%20able%20to%20select%20multiple%20data%20from%20a%20spreadsheet%20to%20produce%20a%20second%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294708%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20after%20selecting%20data%20from%20one%20tab%20and%20moving%20it%20to%20a%20second%20tab.%20In%20the%20first%20tab%2C%20I%20have%20a%20range%20of%20data%20including%20operator.%20I%20then%20want%20to%20select%20all%20of%20the%20jobs%20for%20a%20selected%20operator%20from%20tab%201%20and%20get%20them%20also%20showing%20in%20tab%202.%20I%20have%20used%20a%20lookup%20formula%20but%20this%20only%20finds%20the%20first%20occurrence%20of%20the%20operator%20and%20shows%20this%2C%20I%20would%20like%20to%20be%20able%20to%20look%20up%20multiple%20occurrences%20and%20show%20them%20in%20tab%202.%3C%2FP%3E%3CP%3ECan%20anyone%20help%3C%2FP%3E%3CP%3ECheers%26nbsp%3B%3C%2FP%3E%3CP%3ETony%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1294708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1295018%22%20slang%3D%22en-US%22%3ERe%3A%20Being%20able%20to%20select%20multiple%20data%20from%20a%20spreadsheet%20to%20produce%20a%20second%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1295018%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615358%22%20target%3D%22_blank%22%3E%40Robsot100%3C%2FA%3E%26nbsp%3BIf%20you%20are%20on%20Office365%20(Monthly)%20you%20can%20use%20FILTER%20to%20achieve%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, I'm after selecting data from one tab and moving it to a second tab. In the first tab, I have a range of data including operator. I then want to select all of the jobs for a selected operator from tab 1 and get them also showing in tab 2. I have used a lookup formula but this only finds the first occurrence of the operator and shows this, I would like to be able to look up multiple occurrences and show them in tab 2.

Can anyone help

Cheers 

Tony

1 Reply
Highlighted

@Robsot100 If you are on Office365 (Monthly) you can use FILTER to achieve this.