+ Reply to Thread
Results 1 to 3 of 3

return multiple records matching multiple criteria

  1. #1
    Karthik
    Guest

    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


  2. #2
    Ardus Petus
    Guest

    Re: return multiple records matching multiple criteria

    You could use Data>Filter>Autofilter or Advanced filter

    HTH
    --
    AP

    "Karthik" <karthik_mails@rediffmail.com> a écrit dans le message de
    news:1143044530.884448.104150@i40g2000cwc.googlegroups.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
    >




  3. #3
    Karthik
    Guest

    Re: return multiple records matching multiple criteria

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1