+ Reply to Thread
Results 1 to 4 of 4

Match results of column based on a value from a cell

  1. #1
    Registered User
    Join Date
    11-13-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    77

    Match results of column based on a value from a cell

    Hi
    I would like a formula to match results based on a cell value (Sheet2, cell D1).
    The attached excel shows data in Sheet1 and the expected results in Sheet2.
    As an example if D1 has a value of C, then the corresponding values should read 20, 16, 9, 6 and 50 from C2 to C6.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Match results of column based on a value from a cell

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

  3. #3
    Registered User
    Join Date
    11-13-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: Match results of column based on a value from a cell

    Dear Fluff13
    Works perfect.
    Thank you.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Match results of column based on a value from a cell

    You're welcome & thanks for the feedback

+ 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] Filter results based on cell value and print results
    By MPXJOHN in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-25-2018, 11:38 AM
  2. Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  3. Match number in column G and return column B results to new sheet
    By dettrix in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2013, 01:37 AM
  4. Replies: 3
    Last Post: 06-06-2013, 12:51 PM
  5. Replies: 2
    Last Post: 07-08-2012, 12:42 PM
  6. Replies: 1
    Last Post: 07-01-2011, 07:21 PM
  7. Replies: 4
    Last Post: 12-14-2009, 03: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