Excel 2000 Data Valadation, VLookUp, NameRange, with multiple crit

[Paradigm]

I'm Creating an estimating spreedsheet.
I have a cell A1, for the type of system I want to cost.
Cell A2, I want to insert the name range of my database with ...
=IF(A1=???, Name Range).
How do I do Data Valadation in cell A3, on A2 in order to use VLookUp for
the correct DBList.

Do I need a sperate Row for each System I want to cost and leave the other
rowws blank?

Can data Valadation be done on multiple choices in the same row with IF,
And, Or?

Paradigm

 

[Luke M]

Take a look at Debra's article on Dynamic Validation, which is what I believe
you are trying to accomplish.

http://www.contextures.com/xldataval02.html