Data Validation with VLookup

I have a large table which includes both numerical and text information.

I need to be able to make a series of data validations that are dependent on one another. For example, the first data validation will ask you to choose the "Focus Area" of a tool. This will generate a list of only the tools that exhibit the choosen focus area. Then you have an option of a second data validation asking you to choose the "scale of application" of a tool. The second data validation should read only from the results of the first data validation, taking a subset of the selected focus areas that have a certain type of application. After four data validation choices, you would result in a smaller list of tools that meet all four criteria.

See attached excel file for the macro list that I am using. excel forum help.xlsxexcel forum help.xlsx

I think I must use vlookups within the validation, because my excel sheet includes a series of 0's and 1's to identify if a certain tool has a certain criteria. I have tried for hours to make this work - and I am about to jump out my window in desperation.

Any help is appreciated.

Kind regards,
Anna

I want Horizontal Vlookup formula Validation.it is possiable.Because Normal excel vlookup formula i am using take calculation more time.