Use variable parameters in a TSQL stored procedure

I am new to TSQL and this is the first time I have encountered this situation.
I have a very simple sql statement...SELECT field FROM database where item=?
I would like to use the cells in column D in my Excel sheet and place the field returned in column E of the same row.
I have no idea how to do this...any suggestions?

Use t-sql in excel?

Yes...I use Get External Data and use my SQL server as the Database.
In the connection that is created, I use an SQL statement to get the data.

Can you post table schema with some sample data and results you like to see?