I am using Excel 2007.

I have two named ranges: Customer_ID and Customer_Name.

I currently have a data validation list with the source '=Customer_ID'.
This works fine to look up customer numbers or I can change the source to
'Customer_Name' and look up by name. At some times it's easier to lookup by
name, and others by number. Is it possible to have the drop down list
display both?