Value corresponding to the name

[shimaa01234]

HI,
I own this table
1 - There's column "A" Names
2 - There's column "B" Values
The cell "C1" drop-down list of names
I want when the name selection is brought corresponding value even if repeated Name?
I want the solution by formulas

M1	2	M1
M2	3	2
M1	5
M3	6
M4	8
M5	0
M1	4

<tbody>
</tbody>

 

[shimaa01234]

up

 

[West Man]

=LOOKUP(C1,A1:B7,2,False)

 

[shimaa01234]

Sorry
This formula is not working

 

[WarPigl3t]

The reason Westman's formula isn't working is because lookup only finds the first value in the range. You are looking to display all the values that match C1. So if there are 3 values that say M1 in column A, and you select M1 from the drop down list, then all 3 of the corresponding values for each M1 should be displayed. In your example table, the output to M1 should be 2, 5, and 4. Let me finish my cig and I'll get right on it.

 

[WarPigl3t]

Alright home slice I got your answer. Check it....

	A	B	C	D
1				M1
2	M1	2	2	2
3	M2	3		5
4	M1	5	5	4
5	M3	6
6	M4	8
7	M5	0
8	M1	4	4

<tbody>
</tbody>

Alright so first off I moved your data one row down starting at A2. Then I created a column C. Put this equation in C2...

=IF($A2=$D$1,$B2,"")

Copy the equation down all the way to C8.
Now in D2, enter this equation...

=IFERROR(INDEX(C$2:C$8,AGGREGATE(15,6,(ROW(C$2:C$8)-ROW(C$2)+1)/(C$2:C$8<>""),ROWS(C$2:C2))),"")

Copy that code down all the way to D8.
Now you right click on column C and hide it so the user doesn't see it.

If this fixes your problem, reply with SOLVED.
Do me a personal favor and like my YouTube video about an excel work schedule maker I just built.
Excel Schedule Builder Instructional Video - YouTube

 

[shimaa01234]

Sorry, this formula is not working with Office 2003
Is it possible to bring the result without additional columns

 

[WarPigl3t]

Sorry my formula didn't help you. I tested it before I posted it and it works with Excel 2010. It is not possible to accomplish this task without that additional column unless you decide you want to use VBA. If you decide to use just formulas, you need that extra column to get rid of all the blanks and create a list like I did in column D.

 

[shimaa01234]

This link to the file
https://app.box.com/files/0/f/0

 

[WarPigl3t]

This link to the file
https://app.box.com/files/0/f/0

I cannot access that file. It is protected in your account.
Email it to me and i'll see if i can solve it
RA.Ledesma@yahoo.com