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

 

[Fluff]

Try
=IFERROR(INDEX('Pending Data'!$C$2:$C$1364,SMALL(IF('Pending Data'!$B$2:$B$1364=$B$5,ROW('Pending Data'!$B$2:$B$1364)-ROW('Pending Data'!$B$2)+1),ROWS($1:1))),"")

 

[corppunishment11]

Still comes back blank.

So frustrating

I can't thank you enough for sticking with this!

 

[corppunishment11]

This is the data on the Pending Data sheet

B2 C2

[TABLE="width: 286"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: center"]#N/A[/TD]
[TD]723516[/TD]
[/TR]
[TR]
[TD="align: center"]#N/A[/TD]
[TD]A78276[/TD]
[/TR]
[TR]
[TD="align: center"]#N/A[/TD]
[TD]00581[/TD]
[/TR]
[TR]
[TD="align: center"]#N/A[/TD]
[TD]13532[/TD]
[/TR]
[TR]
[TD="align: center"]#N/A[/TD]
[TD]13533[/TD]
[/TR]
[TR]
[TD]SMITH, JOHN[/TD]
[TD="align: right"]13333[/TD]
[/TR]
[TR]
[TD]SMITH, JOHN[/TD]
[TD="align: right"]551[/TD]
[/TR]
[TR]
[TD]SMITH, JOHN[/TD]
[TD="align: right"]635[/TD]
[/TR]
[TR]
[TD]SMITH, JOHN[/TD]
[TD="align: right"]12130[/TD]
[/TR]
[TR]
[TD]SMITH, JOHN[/TD]
[TD="align: right"]13350[/TD]
[/TR]
[TR]
[TD]SMITH, JOHN[/TD]
[TD="align: right"]13714[/TD]
[/TR]
[TR]
[TD]SMITH, JOHN[/TD]
[TD="align: right"]978[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD="align: right"]1088[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD="align: right"]1153[/TD]
[/TR]
[TR]
[TD]SMITH, CHRIS[/TD]
[TD="align: right"]1154[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

You need to get rid of the #N/A values, otherwise it won't work

 

[corppunishment11]

Okay. Filtered out n/a and blanks. Still returns blank