Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: searching rows for data from other sheet

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need some guidance on what approach to take for this task.
    I have one sheet with many rows of multiple cloum data. I have a 2nd sheet with 25 values. I want to search the 1st sheet for all rows containing any of the 25 values from second sheet and create a 3rd sheet with the row data found.
    I have a medium knowledge of excel. If anyone could tell me
    1. Is it possible to do this.
    2. What appoach should I take.
    I am willing to go out and use the help to learn new features. Please guide me in what I should be looking for.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi joed,

    Can you get away with using a series of Vlookups? Or are you hunting for a vba solution?

    Adam

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't know what vlookups are. I am looking for what ever might work. I will spend some time checking what vlookups are and see if that will work.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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