Hello Everyone,

First post and I appreciate all help.

In the data tab I successfully made a connection to a table from and internal website.
My query is a connection only and I called it table 2. When I hover over that connection I see the table, columns, and data.

My question is, how do I address a specific data value in that table to populate a cell? How do I access specific values in that query?

I found plenty of information to populate sheets with the table as a whole, but can I just maintain that connection and pull specific data rather than populating a new sheet and copying specific data?