multiple value lookup

[Benny]

Hi,
How can I use more that Creiteria to check ????
e.g

A1 want to know what is the value in in clomun D if matches with Mat1
first,or second M_A_2 Exist, or third A_B_A exist all in column C???


C D
1 MAT_1 5
2 M_A_2 6
3 2_A_2 9

 

[Max]

Hazarding a guess here .. perhaps a possibility using autofilter on a helper
col

Assume your col C values are in C2 down
Put this in say, E2:
=IF(SUMPRODUCT(--({"MAT_1";"M_A_2";"2_A_2"}=C2))>0,"x","")
Copy E2 down to the last row of data in col C. Col E flags (with an "x")
values within col C which are either: "MAT_1" or "M_A_2" or "2_A_2". Then you
could simply apply autofilter on col E, choose: x, to return the required
results at one go.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik