Google Sheets Unable to parse query string for Function QUERY parameter 2: NO_COLUMN:

Viewed 1681
1 Answers

use:

=QUERY(Sheet2!A1:D10, "SELECT C WHERE A = "&B1&" AND B = '"&D1&"'", 0)

enter image description here

Related