VLOOKUP Problem - Duplicate information

[zacra777]

Hi, I'm stuck and I'm not sure what to do. I'm not what you would call an Advanced Excel user but I'm able to get around and most of the formulas make sense. I've linked an image of what I'm trying to do. Essentially, I'm trying to take information from the Total Responses section and show it on the Top Attributes of Focus section. What I'm getting stuck at is if the number values match it duplicates the entry instead of listing all values. An example: I want to list the top 4 attributes of focus. I take the attributes with the largest number and I use VLOOKUP It takes the largest value and lists them. In the example you'll see the lists on the left side.If there is multiple cells with the same "Largest value" it only lists one of them but displays it multiple times instead of displaying all information with that value. You'll see it shows "C" multiple times. Since C and D share the same value, I want it to list both of them. Instead it lists C twice.Hopefully this makes sense. Please look at the image found here. VLOOKUP Issue - Album on Imgur

 

[AhoyNC]

See if this does what you want.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Change ranges to match your data.
Drag formula down as needed.

Excel Workbook
	A	B	C	D
1	10	a
2	11	b	14	c
3	14	c	14	d
4	14	d	11	b
5	14	e	10	a
6	6	f
7	6	g
8	8	h
9	5	i
10	4	j
11	2	k
Sheet

 

[zacra777]

That helps a lot! Question, what if, in your example, Column A changes numbers? Would this formula you've given me automatically change with those numbers?

 

[AhoyNC]

Yes (if I understand your question). You should be able to change numbers in both the column A and C and the formula will adjust.

 

[zacra777]

This really helped me out and worked perfectly! Follow up question. In the example I provided all my referenced cells were in Columns. How would I change this formula if I wanted to do the same thing but the information was in rows? In this example I have the "score" in the first row and the "category" in the second row. The second table needs to be able to reference the 1st table and spit out information in this particular format. I've tried messing with the formula you provided but it doesn't appear to be working. Would I change ROW to COLUMN? Any additional help would be greatly appreciated. Thank you!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Score[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]e[/TD]
[/TR]
</tbody>[/TABLE]

 

[zacra777]

This really helped me out and worked perfectly! Follow up question. In the example I provided all my referenced cells were in Columns. How would I change this formula if I wanted to do the same thing but the information was in rows? In this example I have the "score" in the first row and the "category" in the second row. The second table needs to be able to reference the 1st table and spit out information in this particular format. I've tried messing with the formula you provided but it doesn't appear to be working. Would I change ROW to COLUMN? Any additional help would be greatly appreciated. Thank you!

[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Score[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]e[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Try:
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.

Excel Workbook
	A	B	C	D	E
1	3	3	4	5	3
2	A	b	c	d	e
3
4	Score	Category
5	3	A
6	3	b
7	3	e
Sheet