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:

CodePudding user response：

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))

CodePudding user response：

use:

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