Match up 2 lines to their values in a table and check condition.

[stockgoblin42]

Hi,

I'm messing around with lines and intersections.

Please see attached. In the top left I have my main 3 lines, the yellow and red ones vary, the green stays the same.

Underneath is a table of 6 lines, the green, which stays put and 5 others that vary, including the yellow and red.

What I have to do is determine where in the table the yellow and red lines are so I can get the condition that is associated with those lines, beit "Yes" or "No". This is tough because the yellow and red lines can be in any position of the 5 line table.

The worksheet included is just a values page of my bigger workbook. It's showing a false positive because I thought my condition was satisfied if the table showed 2 or more "Yes" but as you can see it shows 2 "yes" but the red and yellow lines, which are the only ones that matter both show "no".

How would I determine where the red and yellow lines are in the 5 line table and if they are saying "yes" or "no"?

Any help is appreciated. Thanks in advance!

[stockgoblin42]

use Vlookup, duh!