help please, not sure if this is hlookup, index or whatever!

[Stuneedshelp]

Hello

I need to find a way to search a tab of data for results and then display specific results based on that and I have no idea what method I would use to go about that.


I have a sheet that looks like this

and on another tab I need a formula to return value of the cell in Row D if certain questions have a 'No' value. EG if J2 contained a 'No', I want the formula to return the value in D2 and so on.

If it's easier to use VBA, then that's fine. I have some limited knowledge on how to use that.

I've tried to research this myself but keep bouncing between different methods that I have no idea how to use. any help would be greatly appreciated!
[TABLE="width: 1157"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]