Google Spreadsheet trick

Question

Here is sheet 1:

Here is sheet 2:

From a Google Spreadsheet, each time I have a ticker/symbol from sheet 2 which is also in sheet 1, I want to copy and paste the line from sheet 1 into sheet 3. Here is a test spreadsheet: https://docs.google.com/spreadsheets/d/1GxljIY-lm5P-pTssKlRAQoyozdb_fhADhpIfUvWkdqo/edit?usp=sharing. Do I have to build a macro or I can use the FILTER() and LOOKUP()function? How can I do that easily?

player0 · Answer

use:

=FILTER(Sheet2!A2:I, COUNTIF(Sheet1!A2:A, Sheet2!A2:A))

Osm · Answer

Use this formula in Sheet3!A1

={"Symbol"; Sheet2!A2:A}

marikamitsos · Answer

Try this:

=INDEX(VLOOKUP(UNIQUE(FILTER(Sheet2!A2:A, COUNTIF(Sheet1!A2:A, Sheet2!A2:A))),
                  Sheet1!A2:J,{1,2,3,4,5,6,7,8,9,10},0))