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 DataFilterAutofilter or Advanced filter

HTH
--
AP

"Karthik" a écrit dans le message de
oups.com...
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