That is correct, the formula/function resolves those values but it doesn't copy, so as long as the reference remains healthy it should be dynamic.

cyphercosmo

but this is only a query not a copy, right?

DarthCoin

devs

I need an Excel formula

I was able to do it in Google Sheets with the following:

```
=QUERY(
   A$1:C$6, 
   "SELECT C 
    WHERE A = " & D3 & " 
      AND B = '" & E2 & "'", 
   0
)
```

In this case the first argument `A$1:C$6` could be a range in the same sheet, a different tab, or a different sheet.

The second argument has some concatenation, D3 and E2 which are the service names you listed horizontally plus the ID, so you'll need to reference them in the query and these variables will change for each new value horizontally. So the second will reference D3 and F2 instead.

And then last argument is just to inform the query that the data range has a header and it shouldn't be considered in the query.