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

1. ## 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 .

2. ## 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?

3. ## 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

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

Originally Posted by :) Sixthsense :)
Still missing the base

Where you will select? In which Cell?

I have to select data from column A

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

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

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

Originally Posted by :) Sixthsense :)
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. ## 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?

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

#### 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