+ Reply to Thread
Results 1 to 3 of 3

vlookup to find rows in a table

  1. #1
    Registered User
    Join Date
    01-17-2008
    Location
    canadaaaaa
    MS-Off Ver
    2019
    Posts
    55

    vlookup to find rows in a table

    hello,

    i was looking for a way to find all the lines in a table where the word : "bou" is present and copy those lines containing bou in another tab. this funny feature needs to be working if the lines are hidden or filtered. is someone wise enough to help me do this?

    thanks!
    Attached Files Attached Files
    Last edited by paascal; 12-09-2021 at 09:09 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: vlookup to find rows in a table

    See yellow banner at the top of the page. Attach a file showing sample data, and in another tab manually show what result you want.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: vlookup to find rows in a table

    worksheet name : copy here only what has bou

    Cell A1 formula , Drag down and across

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup table to find email addresses
    By colin7 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 09-30-2019, 05:01 AM
  2. Vlookup look up data value one table to find in another
    By dcarey in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 06-20-2018, 04:33 PM
  3. [SOLVED] To find the rows with vlookup value #N/A
    By sudharshan86 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2014, 03:58 AM
  4. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  5. Using a ADDRESS/MATCH with VLOOKUP to find a value in a table
    By stturn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2013, 02:42 PM
  6. Vlookup return the header name of table (Table of 4 column x 55 rows)
    By sanpat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-09-2013, 11:23 PM
  7. (ask) Vlookup to find max in table list.
    By sr_88 in forum Excel General
    Replies: 3
    Last Post: 08-21-2012, 01:39 AM

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