I have a table on a worksheet called "DealSetup" that looks like this simplified version:
A B 1 John Doe 1 2 Jane Doe 1 3 Mark Doe 2 4 Doug Doe 1 5 Mary Doe 2
I have a table on a worksheet called "List" that I would like to pull the names into from the "DealSetup" worksheet. However, I want only list the names based on the value in column B.
For example, on the "List" worksheet, I'd like to use some sort of INDEX or array function of some kind to look to the "DealSetup" sheet and pull everyone who's column B value is 1 and list them. I do not want any blanks, though. It should look like this:
EVERYONE WITH B COLUMN VALUE OF 1: A 1 John Doe 2 Jane Doe 3 Doug Doe
Or like this:
EVERYONE WITH B COLUMN VALUE OF 2: A 1 Mark Doe 2 Mary Doe
I've been trying a few things with no luck. Not sure where to go from here, so any input would be appreciated!!