Index/Match only returning first found from list

Hello,

I am trying to figure out why the below formula is not returning the match it found on the row, as opposed to the first found. The below formula (in regards to the example) would go in D1.

Please Login or Register  to view this content.

......A........B......C.....D.......E
1 Data1 Data2 Yes Data1 Data2 <---- correct, but it now copies Data1 and Data2 in all matched with "Yes":

2 Data3 Data4 Yes Data1 Data2 <---- incorrect, D & E should copy Data3 and Data4

3 Data5 Data6 Yes Data1 Data2 <---- incorrect, D & E should copy Data5 and Data6

4 Data7 Data8 Yes Data7 Data8 <---- This is how it should return when "Yes" is found in C

Essentially the formula just needs to return data from the row it is on. I attached an example that will hopefully help. Thank you.

This ??

in E4

=IF($D4="Yes",B4,"")

copy to F4

Then copy down E & F

Wow. You're right. I completely was overthinking it. Thank you for the info. I feel silly now haha.