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

#N/A	723516
#N/A	A78276
#N/A	00581
#N/A	13532
#N/A	13533
SMITH, JOHN	13333
SMITH, JOHN	551
SMITH, JOHN	635
SMITH, JOHN	12130
SMITH, JOHN	13350
SMITH, JOHN	13714
SMITH, JOHN	978
DOE, JOHN	1088
DOE, JOHN	1153
SMITH, CHRIS	1154

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[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