Linked Lookup IF 2 conditions are satisfied

[reghu]

Hi, I have attached a workbook which contains the following sheets
DataAsset
ValueAsset
Data
Asset
Value
Countervalue
Consolidate

in the first two sheets, the user will have the option to select what data is applicable to an asset and in the second what value is applicable to an asset.

the data, asset, value and countervalue sheets are the master sheets for the other sheets. for everyvalue there maybe 1 or more countervalues. in the consolidate sheet, when a user selects an asset, those data that are relevant for that asset should be listed in a dropdown and corresponding values and their corresponding countervalues .

can anyone help me out with this?

cheers
reghu