Hello all, apologies for the lousy title – I find it hard to describe. Could anyone advise if the following is possible please.
I’m trying to design a table below which includes four fields across D-G that need to be populated (in one go) using the dropdown function.
I would like the user to be able to select one field in just one of the columns and then have all four fields populated.
These four columns (client code, project ref, project name, details) are the same in the source data table K-N on another tab (or even conceivably in a separate sheet at a later time but baby steps first!).
However, in order to make the selection correctly, the user needs to see all four columns of data when choosing from the drop down, in order to make the right selection, as each field is duplicated in other rows anfd therefore only the overall combination is unique.
I realise that one option would be to concatenate the original four columns of source data and then do a vlookup from this extra column in both source data and final table. I will if I have to, but I don’t really want the concatenated source data shown in the final table.
Re-reading my request, I suspect I'm asking the impossible and the concatenate is the only option, but feel free to tell me if so! Either way I will have been educated. Thank you for any help!
I’m trying to design a table below which includes four fields across D-G that need to be populated (in one go) using the dropdown function.
I would like the user to be able to select one field in just one of the columns and then have all four fields populated.
These four columns (client code, project ref, project name, details) are the same in the source data table K-N on another tab (or even conceivably in a separate sheet at a later time but baby steps first!).
However, in order to make the selection correctly, the user needs to see all four columns of data when choosing from the drop down, in order to make the right selection, as each field is duplicated in other rows anfd therefore only the overall combination is unique.
I realise that one option would be to concatenate the original four columns of source data and then do a vlookup from this extra column in both source data and final table. I will if I have to, but I don’t really want the concatenated source data shown in the final table.
Re-reading my request, I suspect I'm asking the impossible and the concatenate is the only option, but feel free to tell me if so! Either way I will have been educated. Thank you for any help!