Results 1 to 3 of 3

Search Cell Value in Column and Populate Column Result with Row

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2014
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    9

    Search Cell Value in Column and Populate Column Result with Row

    Hi,

    I wish to search a column with a cell value. I then wish to populate the cell rows with the rows from the column result.

    In the example attached I want K2 result to search Cell Vale F2 in Column A.

    =IF(COUNTIF($A:$A,$F2)=0,"No Match",F2)

    L2 is populated with If and Then (probably not the best solution)

    =IF(K2=F2,G2,"")

    Cell M2 is where I get lost and don't know how to populate the data from Result in A6, B6, C6, D6 into K2, L2, M2 and N2. I've also highlight that Cell M3 & N3 differ from H3 & I3.

    I would greatly appreciate some direction towards a solution.

    Thanking you in advance
    Attached Files Attached Files
    Last edited by Verifyor; 11-19-2019 at 09:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search List in a Column Return a Result From Another Column
    By kevb8ll in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2018, 11:40 AM
  2. Replies: 16
    Last Post: 04-05-2017, 10:24 AM
  3. [SOLVED] search result from column into one cell
    By bowen73 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-15-2014, 09:31 AM
  4. [SOLVED] Dynamic search; using column # result to determine column used for column/row match.
    By David Brunk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-18-2014, 09:57 PM
  5. Replies: 9
    Last Post: 11-19-2013, 06:48 AM
  6. [SOLVED] Search Value of column E if exist return value of column B put result in column P
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-23-2013, 11:39 AM
  7. capture unique values from 1 column and populate the result into another column
    By teachMeExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2009, 05:21 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