Results 1 to 3 of 3

partialy search text from list and then past in same worksheet

Threaded View

  1. 05-01-2016, 01:48 PM #1
    mirza5313
    mirza5313 is offline
    Registered User
    Join Date
    04-18-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2010
    Posts
    2

    Exclamation partialy search text from list and then past in same worksheet

    Hey guys I have a excel sheet of around 3 thousands of record, actually i want to search partially text from one list in same worksheet and then copy corresponding part number of that text, text can be partially search example excel sheet attached. please help me for prepare this formula i am not sure but may be lookup or any other formula whatever suitable for this purpose.


    worksheet link

    https://www.dropbox.com/s/k5n0onqa98...heet.xlsx?dl=0
    Last edited by mirza5313; 05-04-2016 at 01:55 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search text list
    By sanju2323 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-28-2017, 07:38 AM
  2. [SOLVED] Search for the text in cell A1 in a list and remove the text if found in the list
    By kak0 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-24-2014, 11:01 PM
  3. [SOLVED] Copy & Past Values from list to cell A1 of each worksheet
    By cchase22 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-04-2014, 11:11 AM
  4. Simple search for text from list, return adjacent text - match / vlookup / index?
    By aceparts in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 01:09 PM
  5. [SOLVED] Search text in cells, find matching text based on list, remove all but one entry
    By adam_mc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 12:50 PM
  6. [SOLVED] Search function to search if worksheet contains specified text
    By mougiasm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2013, 02:50 PM
  7. Search text from another worksheet
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-15-2010, 07:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1