Trying to get all results from sheet 2 where colum A contains the value of cell A24 in current sheet.
=QUERY('SHEET2'!1:997, "select B where A contains A24")
CodePudding user response：
In place of A24 you would use '"&A24&"'
Trying to get all results from sheet 2 where colum A contains the value of cell A24 in current sheet.
=QUERY('SHEET2'!1:997, "select B where A contains A24")
CodePudding user response：
In place of A24 you would use '"&A24&"'