I have a table of
terms in Google Sheets. I would like to concatenate a few terms by their ids.
(2,3) should yield
Talla de zapato de mujer, Women’s shoe size. I want to take id list from a separate cell.
So, I tried:
=QUERY(A:B, "SELECT A,B WHERE A=2 OR A=3")
The query works fine, but it's hard to manually extract the 2's and 3's this way.
So I tried:
=QUERY(A:B, "SELECT A,B WHERE A IN (2,3)")
Which does not work (
How can I select ids from a table using a GSheets query using a few ids written in a different cell?