+ Reply to Thread
Results 1 to 7 of 7

Find the match in between two column and print the matched corresponding value in column C

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Find the match in between two column and print the matched corresponding value in column C

    Well I have an excel table (Table 1) with numerous entries (names) in its columns A and B. Now I need to calculate the average from column C bassed upon certain criteria. Let us suppose that if we select Ram from column A (yellow marked cells) , it will display the corresponding values of column C. All we want that along with displaying the values against the column A, it should also display the values against the cells of column B containing Ram (Green marked cells) in them. Output should be like table 2 and table 3, if we select Ram /John each time .
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,690

    Re: Find the match in between two column and print the matched corresponding value in colu

    Still missing the base

    Where you will select? In which Cell?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-18-2014
    Location
    Jeffreysbay, South Africa
    MS-Off Ver
    MAC 2011
    Posts
    10

    Re: Find the match in between two column and print the matched corresponding value in colu

    I have used a "what if" formula to select items with the input fields for the selections are in row 1.

    Hope it help
    Neels
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-23-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Find the match in between two column and print the matched corresponding value in colu

    Quote Originally Posted by :) Sixthsense :) View Post
    Still missing the base

    Where you will select? In which Cell?


    I have to select data from column A

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,690

    Re: Find the match in between two column and print the matched corresponding value in colu

    Quote Originally Posted by jassipox View Post
    I have to select data from column A
    Still you are mis interpreting my question

  6. #6
    Registered User
    Join Date
    08-23-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Find the match in between two column and print the matched corresponding value in colu

    Quote Originally Posted by :) Sixthsense :) View Post
    Still you are mis interpreting my question
    Dear Sense,

    We are having three different column A, B, and C (Input data). Column A as well as column B are having some text value while column C contain integer value. When apply filter in column A and select Ram, Ram should be also selected (if avl.) from column B and print the corresponding value in Column C. Shown in Excel sheet (For example : Table 2 (if Select ram) as well as Table 3 (If select John).

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,690

    Re: Find the match in between two column and print the matched corresponding value in colu

    Instead of picking it in filter why don't you allot two cells to enter the search texts?

+ 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] Compare 2 sheets, match data in 1 column, update row in sheet 2 & add new rows not matched
    By Synchronicity in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-11-2013, 01:21 PM
  2. [SOLVED] Find three highest values on column A and print column B
    By diegodacal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2013, 04:05 PM
  3. Replies: 12
    Last Post: 12-28-2012, 07:49 PM
  4. Replies: 1
    Last Post: 05-06-2011, 03:08 AM
  5. Replies: 3
    Last Post: 08-01-2006, 08:15 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