Data Validation

[doco]

I am wondering if there is a way to have the data validation dropdown to display more than one column in order that the user may select the textual representation of an id field but have the selection bound to the id field displaying only the id instead of the description. Like Access does with a lookup table - IE select the text but store the id...

Make sense?

Thanks In Advance
doco

 

[ConneXionLost]

In Excel, a data validation list (named range) must be a single row or column.

Sorry,

 

[doco]

The work around is to have the data validation column not part of the main array but off to the side then have a lookup in the main array to respond to the user 'text' choice to produce the associate number.

Thanks.