How to use value in cell after filtering data, using data validation list method

[SAGAR KHOLLAM]

how can i get a value in cell after selecting criteria from coloum type1, type2, type3, using data validation list method. also list value behave like filtering, only m,n value should be list in type 2 if I select a in type1

type1 type2 type3 Value
a m o 21
a n p 22
b m q 23
b n o 24
c m p
c n q

type1 type2 type3 Value
List a m o 21 "=21x some function.

Thanks for your valuable time.

[RobertMika]

For the first part of yor question use:
=INDEX($E$4:$E$9,MATCH(TRUE,INDEX($B$4:$B$9&$C$4:$C$9&$D$4:$D$9=B12&C12&D12,),0))

For the second look here for Dependant Validation List
http://www.contextures.com/xlDataVal02.html#Third

[SAGAR KHOLLAM]

I was able to do it, thank you for reply, Dewilk