return multiple records matching multiple criteria

[Karthik]

Hi All,

I have a worksheet with the following data in Sheet1

Col A Col B Col C
Ram ABC Hi-Hi
Ravi CDE Med-Med
Ban ABC Hi-Hi
ASt ABC Med-Med
Son CDE Hi-Med

In Sheet2
A1 has a value from ColB i.e, ABC
B1 has a value from ColC i.e, Hi-Hi

I need the formula to display the matching records of ColA i.e,
Ram
Ban

Similarly if the values A1 and B1 of Sheet2 are changed to CDE and
Med-Med it should display Ravi

I donot want to use advanced filter or Pivot tables

Thanks in Advance
Karthik

 

[Ardus Petus]

You could use Data>Filter>Autofilter or Advanced filter

HTH

 

[Karthik]

I had stated that i donot want to use Advanced filter.
Thanks anyway