How to use cell value in sql query to populate another cell

[oriches2]

As the subject says really, I want to be able to populate a particular cell with a value extracted from a sql database where the sql query uses another cell as a parameter in the 'where' clause of the query.

Thanks in advance

Ollie

 

[Fazza]

Hi, Ollie. Can you just have a formula in the particular cell to a cell populated by the parameterised query? It is simple enough so I'm thinking I don't understand the question. Say the cell driving the parameterised query is A1, and say the query populates (header A5) from A6 down, then in the particular cell just have =A6 or whatever suits the query (it might return many records). OK? Regards, Fazza