+ Reply to Thread
Results 1 to 8 of 8

vloolup or other, how to make statement values by keywords?

  1. #1
    Forum Contributor
    Join Date
    12-20-2016
    Location
    Uzbekistan
    MS-Off Ver
    2016
    Posts
    185

    vloolup or other, how to make statement values by keywords?

    Hello guys,

    I wonder if you could help me to solve this task, which could save my time to drink tea?)
    Attaching list.Untitled.jpg

    Thank You,
    Akmal

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: vloolup or other, how to make statement values by keywords?

    Hi,

    Not sure what you mean by make it automatic.

    This formula should work for you.

    Please Login or Register  to view this content.
    Enjoy your tea!

    Cheers

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,014

    Re: vloolup or other, how to make statement values by keywords?

    .
    Here's a macro. Copy and paste into a Routine Module, activated with a Command Button:

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-20-2016
    Location
    Uzbekistan
    MS-Off Ver
    2016
    Posts
    185

    Re: vloolup or other, how to make statement values by keywords?

    Thank You Southward, that really works.

  5. #5
    Forum Contributor
    Join Date
    12-20-2016
    Location
    Uzbekistan
    MS-Off Ver
    2016
    Posts
    185

    Re: vloolup or other, how to make statement values by keywords?

    i tried macro, but it sorted by companies, as Pivot Table, anyway thank you!

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,734

    Re: vloolup or other, how to make statement values by keywords?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  7. #7
    Forum Contributor
    Join Date
    12-20-2016
    Location
    Uzbekistan
    MS-Off Ver
    2016
    Posts
    185

    Re: vloolup or other, how to make statement values by keywords?

    Understood.

  8. #8
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: vloolup or other, how to make statement values by keywords?

    You are very welcome. Glad I could be of some assistance.

    Cheers

+ 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. [SOLVED] Make Column that Finds Unique Values Based on Keywords without Duplicates
    By daveys93 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2016, 12:33 PM
  2. Complicated If/Vloolup problem (may be VBA)
    By tommagpieconsultants in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2016, 02:49 AM
  3. Complicated If/Vloolup problem (may be VBA)
    By tommagpieconsultants in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2016, 07:02 PM
  4. [SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords
    By zneiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 01:32 PM
  5. designing a macro to find keywords and make an entry into adjacent cell
    By lauriek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2010, 10:32 AM
  6. Column Count in vloolup
    By RANDY IN NC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2008, 02:59 PM
  7. can i make a formula to search keywords in a excel workbook?
    By gorillayam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-14-2005, 11:07 PM

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