Help finding values from columns that match criteria.
If cell in J column has value of S find next value B from same column downwards, then find from that row Close add found value to L column below the row that gave signal S OR if the cell in J column has value of B find next cell downwards that has value of B and from that row find Close and add found value to column M below the row that gave the signal.
<tbody>
</tbody>Thank you for your help. I just cant wrap my head around the index match function
If cell in J column has value of S find next value B from same column downwards, then find from that row Close add found value to L column below the row that gave signal S OR if the cell in J column has value of B find next cell downwards that has value of B and from that row find Close and add found value to column M below the row that gave the signal.
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>