I have managed to create a decent drop down system using linked cells or indirect linked cells, however now I have an issue where the extra cells are taking up way to much space on the sheet. The idea was to allow easy part# entry into the form. You would first select the type manuf. and then the type of device and finally the part number. To do this was taking up three cells when all I needed was the part number and that's it. So what I was wondering was if it is possible to have all this information in a cascading drop box selection and inputted into one cell.


Example


Manufacturer
EST
--------------Type
PHOTO
---------------------------PART#
SIGA-PS (This in the only information that is needed) if possible the Manufacturer name could also be included in the cell as well so the final cell would read


EST SIGA-PS
or just
SIGA-PS


The way it is set up right now I have to use a total of 3 cells just to get a simple part number. I'm really not sure where to begin on this one, as everything I have seen online shows indirect linked cells as the example.

Thanks