Any Excel experts here?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • LarryG
    The Full Monte
    • May 2004
    • 6693
    • Off The Back
    • Powermatic PM2000, BT3100-1
    #1

    Any Excel experts here?

    "Expert" being the operative word. I'd classify myself as either an Advanced Beginner or a Beginning Intermediate, and I'm currently building a workbook that is stretching the limits of what I know how to do.

    Specifically, I have a database that I need to search for matching values in the various rows and, if found, extract some of the data from those rows and dump them into another worksheet in the same workbook. I'm fairly sure I can't do it with either VLOOKUP or HLOOKUP; beyond that, I'm stumped.

    If anyone is willing to take a crack at this, I'd shorely be much obliged ...
    Larry
    Tags: None
    • bigsteel15
      Veteran Member
      • Feb 2006
      • 1079
      • Edmonton, AB
      • Ryobi BT3100
      #2
      Originally posted by LarryG
      "Expert" being the operative word. I'd classify myself as either an Advanced Beginner or a Beginning Intermediate, and I'm currently building a workbook that is stretching the limits of what I know how to do.

      Specifically, I have a database that I need to search for matching values in the various rows and, if found, extract some of the data from those rows and dump them into another worksheet in the same workbook. I'm fairly sure I can't do it with either VLOOKUP or HLOOKUP; beyond that, I'm stumped.

      If anyone is willing to take a crack at this, I'd shorely be much obliged ...

      PM sent, I think I can help.
      Brian

      Welcome to the school of life
      Where corporal punishment is alive and well.

        Comment

        • greencat
          Established Member
          • Dec 2005
          • 261
          • Grand Haven Mi
          • 3100
          #3
          Originally posted by LarryG
          "Expert" being the operative word. I'd classify myself as either an Advanced Beginner or a Beginning Intermediate, and I'm currently building a workbook that is stretching the limits of what I know how to do.

          Specifically, I have a database that I need to search for matching values in the various rows and, if found, extract some of the data from those rows and dump them into another worksheet in the same workbook. I'm fairly sure I can't do it with either VLOOKUP or HLOOKUP; beyond that, I'm stumped.

          If anyone is willing to take a crack at this, I'd shorely be much obliged ...
          I think vlookup is your answer.
          Thanks again,
          Mike

            Comment

            • poolhound
              Veteran Member
              • Mar 2006
              • 3195
              • Phoenix, AZ
              • BT3100
              #4
              I'm intrigued, I would have thought that V or Hlookup should have been able to do that.

              Post the problem and lets see what we can figure out.

              Jon
              Jon

              Phoenix AZ - It's a dry heat
              ________________________________

              We all make mistakes and I should know I've made enough of them
              techzibits.com

                Comment

                • sacherjj
                  Not Your Average Joe
                  • Dec 2005
                  • 813
                  • Indianapolis, IN, USA.
                  • BT3100-1
                  #5
                  If you can't get it solved, PM me. If I can't figure it out in Excel, I'm sure I can script it in a couple minutes.
                  Joe Sacher

                    Comment

                    Previous template Next

                    Footer Ad

                    Collapse
                    Working...

                    We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.

                    By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.

                    I Agree