List return

[vgresia]

Hi there - I am looking to create a dynamic list of unique ID numbers for items matching "Horse" in column J, "Ball" in column I, and that do not contain the word dog in column A. In the example below, this would return the ID numbers 48 and 56. However, the formula would be entered into Sheet 1, while the data is housed on Sheet 2.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]C[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]Pet[/TD]
[TD]Id Number[/TD]
[TD]Toy[/TD]
[TD]Animal[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]12[/TD]
[TD]Ball[/TD]
[TD]Horse[/TD]
[/TR]
[TR]
[TD]Doggy[/TD]
[TD]56[/TD]
[TD]Chew[/TD]
[TD]Cow[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]89[/TD]
[TD]Ball[/TD]
[TD]Pig[/TD]
[/TR]
[TR]
[TD]Bird[/TD]
[TD]48[/TD]
[TD]Ball[/TD]
[TD]Horse[/TD]
[/TR]
[TR]
[TD]Doggy[/TD]
[TD]95[/TD]
[TD]Ball[/TD]
[TD]Cow[/TD]
[/TR]
[TR]
[TD]Doggy[/TD]
[TD]89[/TD]
[TD]Chew[/TD]
[TD]Horse[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]56[/TD]
[TD]Ball[/TD]
[TD]Horse[/TD]
[/TR]
[TR]
[TD]Bird[/TD]
[TD]56[/TD]
[TD]Ball[/TD]
[TD]Horse[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[vgresia]

That did the trick! Thank you very much for your continued effort (and great use of emojis) on this, much appreciated!

 

[Eric W]

Whew! Glad it all worked out!