I'm truly stuck....

[corppunishment11]

I am trying to write a formula that will look at a constant data point (C2) and return all values related to C2. In other words, list all items from a different spreadsheet that refer to John Doe

Example:

=IFERROR(VLOOKUP($C$2,'sheet1'l$B$2:$C$153,2,FALSE),"")

For the first cell, it returns what I want.

C2: John Doe E2 shows, "1,000,000" perfect.

However, E3 through E150 also show, "1,000,000".

How do I get it to keep looking at C2 but return all of the other values?

Thanks!!

 

[corppunishment11]

Thank you so much!

 

[Fluff]

You're welcome

 

[corppunishment11]

This is great. Can I add multiple original data points?

John Doe
Frank Doe
Chris Doe

and just have it return the associated data like for John?

 

[Fluff]

I don't understand what you are saying.

 

[corppunishment11]

If C2 is a drop down list of names. So, if I use Frank Doe instead of John, will it give the right data back for Frank?

 

[Fluff]

Yes

 

[corppunishment11]

Really? Okay. I'm trying now.

 

[corppunishment11]

Okay. I'm sorry that I keep coming back because you clearly have provided me with enough help.

I cannot get this to translate to my sheet names now. I tried to substitute but no luck.

If you are willing here's what I have:
Yours: {=IFERROR(INDEX(Sheet1!$C$2:$C$28,SMALL(IF(Sheet1!$B$2:$B$28=$C$2,ROW(Sheet1!$B$2:$B$28)-ROW(Sheet1!$B$2)+1),ROWS($1:1))),"")}



Mine now:
Sheet one is:
{=IFERROR(INDEX(Pending!$C$2:$C$1128,SMALL(IF(Pending!$B$2:$B$1128=$b$5,ROW(Pending!$B$2:$B$1128)-ROW(Pending!$B$2)+1),ROWS($1:1))),"")}

I am not getting back the correct data and when I change the name on sheet 2 B5 it doesn't change anything.

Thank you if you can see what I'm doing wrong.

 

[Fluff]

Is the formula in sheet2?
Also if the dropdown is in C2, why did you change $C$2 to $B$5?

 

[corppunishment11]

Hi. Yes, I have the formula on Sheet 2 (Sheet named P on mine) and the drop down was moved to B5 on sheet P