Concatenate dropdown

**tek9step** · 06-19-2009, 06:03 AM

hi i am trying to get 2 rows in one drop down without having to create another combined row. im not sure what formula should i use. I have attached an example for help.

Thanks

**deadlyduck** · 06-19-2009, 06:09 AM

The formula in your data validation source is incorrect.

It should be

Code:

=A3:B3

**tek9step** · 06-19-2009, 06:21 AM

Thanks for the response mate but it is not working. I have given a simple example the actual drop down list has to be in another sheet thats why i have name Row A as Code & B Item so that in drop down i can see them together.

**martindwilson** · 06-19-2009, 06:25 AM

you cant like that, source needs to be in single row or column unlees its changed in 2007

**deadlyduck** · 06-19-2009, 06:34 AM

Deleted post

**DonkeyOte** · 06-19-2009, 06:43 AM

most obvious choice without adding additional cells would I'm afraid be a VBA based ComboBox which can be set to utilise Multiple Columns simultaneously... also has benefits of Auto Complete etc unlike Data Validation.