Please refer the below article by Ashish Mathur

http://office.microsoft.com/en-us/ex...260381033.aspx

If this post helps click Yes
---------------
Jacob Skaria


"Are" wrote:

Dear Masters..

How to find value using some criteria?

example
[A] [b]
A B1
A B2
A B3
C E2
C E3

if I type A in column [b] will appear B1
B2
B3

result like :

A B1
B2
B3


Thanks in advance

Regards