corppunishment11
Board Regular
- Joined
- Dec 7, 2018
- Messages
- 51
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!!
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!!