Excel grab data from MS SQL Server with WHERE clause based on cell contents There's a bunch of questions for similar things, but I've been unable to find anything that fits.

We have three columns:

Name   |    ID    |    Cost
Thingy       3          25
Other        11         5

Only ID is manually entered. Name and cost on that row are then fetched automatically from an MSSQL database.

I've been looking at using Microsoft Query data source with ? in the WHERE clause to then add parameters based on cell contents but firstly, the parameters button is greyed out and secondly, even if it worked, it seems like I'd need to manually create queries for every single row with cell reference hardcoded in rather than one cell query that could be replicated down the name and cost columns.

Any guidance would be hugely appreciated.
Could you make a tab in your sheet that holds all of your SQL data?  Each time you load your sheet you could refresh this data to make it fresh then everything else could be an Excel formula (lookup on SQL tab) to get at what you want.  My reason for suggesting this is you sound a lot more familiar with Excel over MS Query.  

Otherwise in MS Query use your table as a data source and join with the SQL data (again I'd probably throw the result in a new tab)