+ Reply to Thread
Results 1 to 5 of 5

LOOKUP Value Based on Partial Text available in a Cell

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    LOOKUP Value Based on Partial Text available in a Cell

    Thank You So Much!
    Last edited by Rajeshkumar R; 01-21-2017 at 03:02 AM. Reason: Query Solved

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,430

    Re: LOOKUP Value Based on Partial Text available in a Cell

    Your post is very hard to read: please edit it to increase the point size and choose a non-serif font for easy-reading on screen. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,913

    Re: LOOKUP Value Based on Partial Text available in a Cell

    c2
    Please Login or Register  to view this content.
    d2
    Please Login or Register  to view this content.
    try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: LOOKUP Value Based on Partial Text available in a Cell

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

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: LOOKUP Value Based on Partial Text available in a Cell

    Glad to help and thanks for feedback.

    But never delete description of problem from first post because in the future, people with a similar problem will not know what the problem concerned

+ 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] Find cell in array that contains partial text and use column # of cell to lookup value
    By chuckyfang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2016, 10:19 AM
  2. Partial lookup from text string, return value from lookup list
    By TotallyLost in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-13-2016, 12:14 PM
  3. Replies: 4
    Last Post: 11-11-2015, 12:05 PM
  4. [SOLVED] Help using VBA to highlight a partial column based on text in a cell out of the range
    By JTKEXCEL in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-20-2013, 04:46 AM
  5. Deleting rows based upon partial cell text
    By mjwillyone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2008, 10:29 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