Need a Google Spreadsheets Guru?

Question

Google

Help to leave the formula. The essence of a formula in a query that selects one value from columns with a condition.
So,
here is the formula =query(MY!B:D; "select C where B = D2")
MY is the name of the sheet,
the range of columns for parsing B - D
, you need to select a value from column C
, while the corresponding value of column B must be equal to a cell! D2, in which the value is formed by another formula
In the current form, D2 is perceived as the name of the column. If you take it in single quotes, it will be perceived as just text.
Thanks in advance!

Answer 1

=query(MY!B:D; "select C where B = " & D2)