Hope you can help me.
I have a sheet called "SPARES" with an excel table with headings "Code", "Description" and "Price" - the table is called "SPARES". On a sheet called "Table 1" in cells B36:B40 (named SPARES_CODE) I have created a data validation dropdown list in B36:B40 which automatically gives me a list of the "Code" column. I then use a vlookup to populate columns C & D based on my selection. The problem I have is I have 1765 Codes - so without a description, it does not really help. Is there a way I can have my validation list show (=SPARES_CODE&" - "&SPARES_DESCRIPTION) EG 923262 - WBE 1234 Machine - but only put "Code" (923262) in B36:B40?
I have a sheet called "SPARES" with an excel table with headings "Code", "Description" and "Price" - the table is called "SPARES". On a sheet called "Table 1" in cells B36:B40 (named SPARES_CODE) I have created a data validation dropdown list in B36:B40 which automatically gives me a list of the "Code" column. I then use a vlookup to populate columns C & D based on my selection. The problem I have is I have 1765 Codes - so without a description, it does not really help. Is there a way I can have my validation list show (=SPARES_CODE&" - "&SPARES_DESCRIPTION) EG 923262 - WBE 1234 Machine - but only put "Code" (923262) in B36:B40?
