software

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
KarthikYou could use Datagt;Filtergt;Autofilter or Advanced filter

HTH
--
AP

quot;Karthikquot; gt; a écrit dans le message de oups.com...
gt; Hi All,
gt;
gt; I have a worksheet with the following data in Sheet1
gt;
gt; Col A Col B Col C
gt; Ram ABC Hi-Hi
gt; Ravi CDE Med-Med
gt; Ban ABC Hi-Hi
gt; ASt ABC Med-Med
gt; Son CDE Hi-Med
gt;
gt; In Sheet2
gt; A1 has a value from ColB i.e, ABC
gt; B1 has a value from ColC i.e, Hi-Hi
gt;
gt; I need the formula to display the matching records of ColA i.e,
gt; Ram
gt; Ban
gt;
gt; Similarly if the values A1 and B1 of Sheet2 are changed to CDE and
gt; Med-Med it should display Ravi
gt;
gt; I donot want to use advanced filter or Pivot tables
gt;
gt; Thanks in Advance
gt; Karthik
gt;
I had stated that i donot want to use Advanced filter.
Thanks anyway