I would like to identify a "Y" when it shows up in a column, and then compare
a value in one cell (A2) with the four values in the row next to the "Y"
indicator. Can anyone help with this? The "Y" will move up or down within
the column depending on values entered in the worksheet, and I already have
this part of the formula completed. The value in cell A2 will change. If A2
is greater than the number in column D, then D is returned. If A2 is greater
than the number in column E, but not greater than the number in column D,
then E would be returned, etc. V 2003
D E F G
N 50 40 30 20
Y 45 35 30 25
N 35 30 25 20