Results 1 to 8 of 8

Search and identy user name from description

Threaded View

  1. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: Search and identy user name from description

    In the meantime and in the event you have Product 2021 or newer try this formula in H3 and copy down.
    Formula: copy to clipboard
    =INDEX(FILTER($C$3:$C$11,ISNUMBER(FIND($C$3:$C$11,G3))),1)


    I could not follow the information in "Comments". This is the best I could do. I suspect it is not what you expect. In column J
    Formula: copy to clipboard
    =INDEX(FILTER($C$3:$C$11,ISNUMBER(FIND($C$3:$C$11,G3))*(E3=$A$3:$A$11)*(F3=$B$3:$B$11)),1)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search keyword in description and return value
    By brourmind in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-21-2022, 08:00 AM
  2. [SOLVED] Search the value and removed same value from description
    By jc83ph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2020, 03:14 AM
  3. Description Search For Inventory
    By Kollasch40 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2016, 12:01 PM
  4. [SOLVED] Search and Extract text from a list of description
    By ADLT in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-16-2016, 02:23 AM
  5. User Input Description to SKU 'Smart Code'
    By twistedweb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2014, 02:04 PM
  6. [SOLVED] Search for SKU, if match then copy description from 1 Workbook in another
    By tripey in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-28-2013, 11:54 AM
  7. User Defined Function Description
    By djt76010 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2008, 06:45 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