Results 1 to 3 of 3

search a value in array & if the value is present in array return yes/no in the same row

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2021
    Location
    Hyderabad
    MS-Off Ver
    11
    Posts
    2

    search a value in array & if the value is present in array return yes/no in the same row

    I have a list of values to be searched (column B) which I want to search in Main Array (column A) and if the value is present in MAin Array (column A) the formula should return the value in column c on the same row as it is in column A


    FOr e.g. : Search GHI (from column B) in column A, it is present in third row so the formula in column c should return GHI in the third row as shown in the below given table


    A B C
    Main
    Array Value to be searched
    in the main array Searched Value to be
    returned on the same row as the Main Array
    ABC GHI NA
    DEF JKL NA
    GHI XYZ GHI
    JKL OPQ JKL
    LMN NA
    OPQ OPQ
    RST NA
    UVW NA
    XYZ XYZ








    Please help with the formula as i have thousand lines to be searched.

    Thanks,
    Pankaj
    Last edited by panksona05; 07-22-2021 at 03:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA search array and return value
    By carrollm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2020, 02:50 AM
  2. [SOLVED] Compare two string array and list what is not present in array 2
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2019, 01:31 PM
  3. Replies: 1
    Last Post: 02-26-2019, 01:05 PM
  4. Search an array with an array and return matching value
    By cheal2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-23-2013, 04:15 PM
  5. Replies: 5
    Last Post: 11-20-2013, 10:45 AM
  6. Replies: 2
    Last Post: 05-31-2010, 12:06 PM
  7. Search array and return element No
    By Ron in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-17-2006, 12:35 AM

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