Comparing text location between two columns to return value in third and fourth column

[y3tter]

In column A1:A14 the term "Red" is displayed in in only one cell and in column B1:B14 the word "Target" is displayed in only one cell. I want to return a value in in Cell C1 that says "Above" if "Red" is above any row position than "Target", and display "Below" in cell C1 if "Red" is on an equivalent or less row position as "Target". In Cell D1, I want to do something similar, if "Red" is on equivalent or greater row position as "Target", I would like cell D1 display "Above" and if "Red" is below the cell row of "Target", to display "Below" in cell D1. Is there an easy way to accomplish this?

 

[Fluff]

How about
=IF(MATCH("red",A1:A14,0)< MATCH("target",B1:B14,0),"Above","below")
for C1

 

[y3tter]

How about
=IF(MATCH("red",A1:A14,0)< MATCH("target",B1:B14,0),"Above","below")
for C1

That works GREAT!! Thank you for such a quick response!!

 

[Fluff]

Glad to help & thanks for the feedback