How to use Query function with Arrrayformula in Google Sheets?

Question

enter image description hereI am trying to use this Query function within Arryaformula. I got stuck in this. Can anyone try to correct me as this code providing me some errors? I will really appreciate your time.

=ARRAYFORMULA(QUERY('RangeSelected'!1:1001,"SELECT * WHERE (LOWER(B) ='"&'Sheet1 column(A3)'&"'")",0))

Answer 1

try:

=QUERY('RangeSelected'!1:1001,
 "where lower(B) = '"&LOWER(Sheet1!B5)&"'", 0))