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