Validation list - will only show specific list

what i want to do is when I choose a text from the drop down menu in column A, there is only specific texts that will appear in Column B

For ex:
If I choose "Material/tools/equipments", the column B will show the list "Heavy Equipment (crane, semitruck)", "Parts/consumables", "See detailed description", "Tools"
If I choose "Process", the column B wil show "execution", "oil sample"
If I choose "Documentation", the column B wil show "Component documentation", "eQMS documents"...........and so on

Note: I already defined the name of the list (see source validation sheet)

This is what I did: I went to data validation -> List -> and in source:
=IF(A5="Material/tools/equipments";Range2;IF(A5=" Process";Range3;IF(A5=" Documentation";Range4;IF(A5=" Offshore infrastructure";Range5;IF(A5=" Personal";Range6;IF(A5=" Site infrastructure";Range7))))))

----- but seems there is something wrong with the formula


I attached the worksheet i am working on


range question.xlsx

perhaps
=CHOOSE(MATCH(A3;Range1;0);Range2;Range3;Range4;Range5;Range6;Range7)

are you talking about dependent validation lists? see here
http://www.contextures.com/xlDataVal02.html