I have a Dependent Validation data that I need it to complete this statement
IF D2=LOCAL,TECH,FACTORY,OR WEB (TYPES OF CLASSES) IS CHOOSEN
E2=THE INDIVIDUAL TYPE OF CLASS IS AVAILABLE CHOOSE
AND WHEN THE CLASS IS CHOOSEN:
F2=THE COST AUTOMATICALLY POPULATES

ALL THE DATA IS ON A SEPERATE SHEET IN THE WORKBOOK CALLED DATA

COLUM A - THE 4 TYPES
COLUMN B - LOCAL CLASSES
COLUMN C - COST OF EACH LOCAL CLASS
COLUMN D - WEB CLASSES
COLUMN E - TECH CLASSES
COLUMN F - FACTORY CLASSES

4 DIFFERENT COST BUT 3 OF THE TYPES ARE SAME:
TECH AND FACTORY=1000 AND WEB=0 FOR THE CLASS CHOOSEN
LOCAL TYPE IS THE MIND WRENCHING PART OF THIS IT HAS 11 DIFFERENT CLASSES=3
DIFFERENT COSTS

I HAD A IF STATEMENT BUT NOW THAT i HAVE MORE THAN 7 CLASSES FOR LOCAL TYPE,
I NEED HELP!!!!!!!!!!!!!!!!!!!!

SAMPLE DATA AVAILABLE IN SCHEDULE WORKSHEET TO DROP DOWN AND CHOOSE THE TYPE
IN D2 AND E2 MAKES THE DIFFERENT TYPE CLASSES TO CHOOSE FROM AND WHEN THAT IS
CHOSEN F2 AUTOMATICALLY POPULATES THE COST OF THE CLASS:
D E F
2 LOCAL CLASS 1-6 $205.00
WEB CLASS 7-10 $250.00
TRANEONLY CLASS 11 $300.00
FACTORY CLASS 12-28 $0.00
CLASS 29-32 $1000.00
CLASS 32-48 $1000.00


--
Thanks again, Herz and His