I need to find a way to create a drop-down menu in Mathcad that grabs material properties directly from an Excel file, and plugs them into the mathcad workspace. Could someone please point me in the right direction so that I can try to figure this out. I have attached a picture of what this dropdown menu might look like in Mathcad. The other attachment is a sample Excel file that would contain the material properties. Thank you, any help would be greatly appreciated.
