Interdependent searchbox

[Saketshelar]

Hi,
I have a file with 4 columns viz
ID, subcategoryname, propertyname, propertyvalue...the entries are about a million...the Ids repeat too..like 300..300...1256...2165...2165..etc
To every id there's a subcategoryname like 2165 is for matresses...for them there are some properties...and for those properties there are some allowed values...I need a searchbox in which if i put the property name or ID i should get the corresponding values of the other fields in a list...Actually i need a system where i will just enter the property name click the desired result and get the property values and ID for it..

[shg]

Welcome to the board.

Autofilter.