Populate other cells based on pick list selection and db results matching those criterea

I've gotten great help here in the past, so I'm hoping someone can assist here also.

I'm trying to use a pick list to select a machine type. Once selected other cells are filled with the corresponding data. Things like a header and several bullet points and a price. I have all this data in an excel sheet and I've imported it to a SQL database. I've tried several times and have been able to create the connection, but I can't seem to sort out how to query data to individual cells.

Attachment 888304

So from the screenshot, if I pick the machine manually in the "Part Number" column, I'd like the other fields to populate with the corresponding data. My aim was to use a SQL query, something like..

insert [Header$] where [Part Number] = '[Part_Number]'

I'm sure the query isn't quite right, but I haven't even been able to get to the point where I could troubleshoot that portion.

Attached is a sample sheet. Happy to help clarify if this isn't helpful.

Thanks!Screenshot 2025-02-05 162218.png

1) Select cells B2:B5, then in the formula bar, enter*:

Please Login or Register  to view this content.

***Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts braces {} around the formula (though do not attempt to manually insert these yourself).
2) In C2:

Please Login or Register  to view this content.