google-sheetsfilter

Having trouble filtering out data from columns

 Sheet 1                 Sheet 2
     A          B            A        

    oranges    12            oranges    
    peaches    8             apples      
    apples     7             
    bananas    5

Output
   12
    7

=filter(Sheet1!B:B,Sheet1!A:A=Sheet2!A:A)

I know I was able to do this before but something not working here.

Solution

  • You may try:

    =filter(Sheet1!B:B,xmatch(Sheet1!A:A,Sheet2!A:A))