I'm trying to reference Above/Below by looking at column range AF48:AF61 and looking for the word "Red". The second reference is "Base" in column range AH48:AH61. If Red is in a Row above Base, I want to return the value "Above", if Red is in a row equal or below Base, I want to return "Below". Below are three examples. Is there an easy way to accomplish this?
1. Return "Above"
2. Return "Below"
3. Return "Below"
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
1. Return "Above"
2. Return "Below"
3. Return "Below"
Red | ||
Base | ||
<tbody>
</tbody>
Red | Base | |
<tbody>
</tbody>
Base | ||
Red | ||
<tbody>
</tbody>