return multiple records matching multiple criteria

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

You could use Data>Filter>Autofilter or Advanced filter

HTH
--
AP

"Karthik" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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
>

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