+ Reply to Thread
Results 1 to 8 of 8

VBA Lookup Words in column Return multiple results from list

  1. #1
    Registered User
    Join Date
    03-12-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    7

    VBA Lookup Words in column Return multiple results from list

    Hi,

    I have the below it looks at each cell in column D and returns a result from a list (column A), if there is a word found that matches one in column A.

    I would like to return the value in column B instead of A but look still look up the values in column A.

    How would I amend the below to do that:

    Please Login or Register  to view this content.
    Last edited by zombie1; 09-09-2021 at 11:14 AM.

  2. #2
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Lookup Words in column Return multiple results from list

    Hi zombie1,

    Please attach a sample workbook with some example of desired result to understand your requirement.

    Regards,
    Joshi
    Cheers,

    Joshi
    Being with a winner makes you a winner

  3. #3
    Registered User
    Join Date
    03-12-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    7

    Re: VBA Lookup Words in column Return multiple results from list

    Attachment 747083

    I want the results to come back in column E (see image)

  4. #4
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Lookup Words in column Return multiple results from list

    Hi zombie1,

    unable to open the attachment

  5. #5
    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: VBA Lookup Words in column Return multiple results from list

    The paper clip icon does not work for attachments. To attach a file:

    1. Under the text box where you type your reply click the Go Advanced button.
    2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
    3. Click the Choose File button to select a file to attached.
    4. Click the Upload button to upload the file.
    5. Then click the Close This Window button. Your file is now attached to your post.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  6. #6
    Registered User
    Join Date
    03-12-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    7

    Re: VBA Lookup Words in column Return multiple results from list

    Hi,

    Thanks for that.

    I've attached an example..
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Lookup Words in column Return multiple results from list

    Hi Zombie1,

    please copy below formula and paste in cell "E3"
    HTML Code: 

  8. #8
    Registered User
    Join Date
    03-12-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    7

    Re: VBA Lookup Words in column Return multiple results from list

    That works, thanks!

+ 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] Lookup to return results from list based on symbol
    By Excell1677 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-30-2021, 08:07 AM
  2. [SOLVED] Lookup to return multiple results
    By mente73 in forum Excel General
    Replies: 5
    Last Post: 12-04-2020, 01:50 PM
  3. Lookup a Value and Return Multiple Results
    By tigeravatar in forum Tips and Tutorials
    Replies: 13
    Last Post: 04-08-2016, 04:44 PM
  4. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  5. Lookup a Value and Return Multiple Results
    By sgtkikass in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-06-2014, 10:06 PM
  6. Lookup & return Multiple Results
    By benishiryo in forum Excel Tips
    Replies: 2
    Last Post: 07-11-2012, 10:11 AM
  7. Return Multiple Results with Lookup
    By Josh O. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2005, 05:06 PM

Tags for this Thread

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