View Single Post
  #2  
Old 20th October 2005, 08:11 PM
brave chief brave chief is offline
Member
 
Join Date: Jan 1970
Posts: 325
Default

Hey TS,

you certainly can.

Data menu > Validation > on Settings tab, Allow List and add your look-up table in Source

The only drawback is the look-up tables must be on the same worksheet you are using.
Reply With Quote