I'm trying to run a few simple functions, but I can't seem to find any
information on what I'm doing wrong.

1.) Based on a range of inputed data (i.e., <5, >80) in cell BN171, cell
BO171 displays the text "GO" or "STOP".  This repeats itself down the column,
daily, based upon the inputed data.  Cell BP171 displays the text "New
Signal" whenever BO171 changes...if no change from the previous day then
"---" is displayed.

I'm trying to solve for the lookup of the most recent "New Signal" text and
have it displayed in BP 269, BP 270 & BP 271.  So I can, at a glance, see the
most recent 3 days signals.

2.) In trying to do a LOOKUP in a column and display the last displayed
entry (text) which is the result of
=IF(BI173<5,"GO",IF(BI173>80,"STOP",BO172)).
I, again want my result to be displayed in BO271 based upon the most recent
signal (GO or STOP).

Any help would be greatly appreciated.

Tom