Get List Of All Values Corresponding To A Value In The Adjacent Column

[emmye998]

I need help very necessary
I've offered this demand, "Mr. Excel forum"
Frankly, everyone make every effort to help, but all the solutions are not required.
I need a drop-down list, instead of the "Combo Box"
To achieve the same result, but the formulas
Thanks to all

[emmye998]

Link to the forum Thread "Mr. Excel"
May wish to view it
Value corresponding to the name (http://www.mrexcel.com/forum/excel-questions/790649-value-corresponding-name.html)

[Excel Fox]

Here's one way to do it.

=IF(ISERROR(N(INDIRECT("B"&SMALL(IF($A$1:$A$7=C1,ROW($A$1:$A$7)),ROW($A$1:$A$ 7))))),"",INDIRECT("B"&SMALL(IF($A$1:$A$7=C1,ROW($A$1:$A$7)),ROW($A$1:$A$ 7))))

As array formula

[LalitPandey87]

In your example you have used a drop down and based on selection you know the row no of selected value even if it is repeated or not but in case of formula how would excel know which number of instance you are picking.:wakeup::confused:

[emmye998]

Fantastic, Mister, "Fox Excel"
But this solution has been reached in "Mr. Excel" But in another way
But you can show only one value in the cell "D 1" and change with the cell "C 1"
You could be the solution your way?
As a result, as the file sender?
Thank you very much again for this wonderful solution

[Excel Fox]

Just use this formula in C2 and drag down

=IF(D2<>"",C1,"")

[emmye998]

Unfortunately, "Mr. Fox"
This is not required, it seems that I did not explain the idea, well
I want this cell (D1) is changed with the change of the cell (C 1)
Like this:

[Excel Fox]

:) I don't think you understood what I was proposing. Please check the attachment.

[emmye998]

very sorry Mister, "Fox"
For your efforts with me, thank you for your patience my sir
If we changed the title of the post to:
"Get a cell change depending on the change all values​​, even if the value of similar"
We'll get to the solution
It seems I did not explain the topic well yet:
I want to change the cell "D1" change depending on the "C1" Well this is happening.
2 - I want to be changed (D1) even if the condition is a duplicate value corresponding to this condition
In other words, if the "M1" in the column "A" corresponds to "2" in the column "C" shows "2" in cell "D1". If we wrote this "M1" in cell "C1".
If the "M1" in the column "A" corresponds to "5" in the column "C" shows "5" in cell "D1". If we wrote this "M1" in cell "C1".
If the "M1" in the column "A" corresponds to "2" in the column "C" shows "2" in cell "D1". If we wrote this "M1" in cell "C1".

[emmye998]

This I want this idea
I hope that these images are the best explanation
1643
1644
1645

[Excel Fox]

Yeah, so what's your criteria for showing 2, 5 or 4? Is it based on color?

[emmye998]

Not on the basis of color ?
But the color developed by I want to clarify the value corresponding to this condition
Even if the condition repeats in the column
Unfortunately, once again the lack of my ability the explanation

[Excel Fox]

Unless you are able to clearly explain what you need, the volunteers will not be able to help you. Could you find someone in your circle who can translate your requirements in a meaningful way, and not just transliterate what you are saying.

[LalitPandey87]

Add dropdown in the sheet and select data as the source of drop down and select value based on the selection and position you will get the value that's it.

[emmye998]

Without tiredness
Can you give me an example
Because I need this necessary
Has not been realized yet that I want

[emmye998]

Mister, "Fox"
My request is very simple
I want value in column "B", appear when I write the corresponding value in the column "A" even at repeat that value
- When I write the value "M1" in the cell, "A 1" in the column "A", comes the value "2" only and not all the other values
Such as " 5 , 4 ", etc.

[Excel Fox]

Sure. Try this.

[emmye998]

Unfortunately, Mister, "Fox"
The solution is great, but I want only one value appears in cell "d 1" with the value of the corresponding
And is not merged
This is the difficulty that I face, a similarity condition
Thanks again
But it is clear that it is difficult

[Excel Fox]

But I had already given you a solution with one value each. And there are a few other solutions in this thread which gives you only one value. And just now, I've given you a solution which gives all the list in one cell, separated by a comma (,). I have now run out of any assumptions of what you need without you being able to explain clearly what you need.

[Excel Fox]

If any of the developers/members out there can add any more inputs which may give more clarity to the OPs request, would be great.

[Admin]

Hi


In E1

=INDEX(B1:B7,SMALL(IF(A1:A7=C1,ROW(B1:B7)-ROW(E1)+1),D1))

It's an array formula. Where C1 is the dropdown value and E1 is the instance.

Please find attached.

[emmye998]

Great Master "Admin"
You are closer to the solution that I want
But you can change the number, in the column "d 1" automatically, with the change of condition
And why not bring, the rest of the values ​​in the column "A" with the other conditions change
Is it possible to change the values ​​in the column "E" without the column "d"
Thank you all

[Admin]

You got all the possible solutions. What you now want is not possible, though I could be wrong.

Best of luck.

[emmye998]

Yes, I think you're right
Thanks anyway, and unfortunately for your time
Thank you for Mister "Fox" Also, he is a man really nice