lookup

[Are]

Dear Masters..

How to find value using some criteria?

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

if I type A in column will appear B1
B2
B3

result like :

A B1
B2
B3


Thanks in advance

Regards

 

[Jacob Skaria]

Please refer the below article by Ashish Mathur

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

If this post helps click Yes

 

[Are]

Thanks you very much.

Please refer the below article by Ashish Mathur

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

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

Dear Masters..

How to find value using some criteria?

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

if I type A in column will appear B1
B2
B3

result like :

A B1
B2
B3


Thanks in advance

Regards