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

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

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

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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Paradigm" wrote:

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