google sheetsgoogle-sheets-query
This is my test sheet:
https://docs.google.com/spreadsheets/d/11oiKLq6EWk9grdrtIKHT0NQ4naTX_tSPl7o8zAQP3Tc/edit?usp=sharing
My core information is in the sheet labeled "Information." In the sheet labeled "Query" I would like to have a formula look at the value in Query!A1 and compare it to Information!A1:A25.
Since Query!A1 matches Information!A2, then Query!B1 and Query!C1 should contain the corresponding information from Information!B2 and Information!C2.
do it like this:
=QUERY(IMPORTRANGE("1BoIre_wWE6yfiFvLseWGn3XNqK4gUS2wqdVenR32q2M", "CM!A2:G"),
"select Col1,Col5 where Col3 = '"&C1&"'")If you really sure you need IMPORTRANGE then it would be like this:
=QUERY(IMPORTRANGE("1NkCAMrymdPcN29oi_DpHtKbYh7w9tPODzBqU_aCmtnk", "Source!E1:K6"),
"select Col"&MATCH(B$1,
IMPORTRANGE("1NkCAMrymdPcN29oi_DpHtKbYh7w9tPODzBqU_aCmtnk", "Source!E1:K1"), 0)&"
where Col1='"&$A2&"'", 0)
Otherwise, it could be just:
Best Answer
The formula you need uses the
VLOOKUPfunction:Functions used:
Please check the answer in your sheet