Cell Value in Query

13 views
Skip to first unread message

Jean M Delphonse

unread,
Apr 12, 2017, 1:01:03 PM4/12/17
to Google Visualization API
How do I reference a cell using Googles Visualization API's query method?
example:
=query('DataRange'!B3:V179,"SELECT * WHERE F='"D1"' OR G='"D1"' OR H='"D1"'",1)

Cell D1 contains the value that must be referenced.

Jean M Delphonse

unread,
Apr 12, 2017, 3:18:31 PM4/12/17
to Google Visualization API
Problem solved:
=query('DataRange'!B3:V179,"SELECT * WHERE F='"&D1&"' OR G='"&D1&"' OR H='"&D1&"'",1)
Reply all
Reply to author
Forward
0 new messages