Comparing Values, displaying corresponding date

[d.munyan]

There is a threshhold value that I need to compare to projected values.
When the projected value becomes > the threshhold value, I need to
display the date when that happens.

Sounds so simple - but I can't figure out how to do it.

Dates are in rows across the spreadsheet, with corresponding
projections in rows below. Threshhold and current values are in a
second spreadsheet in the same workbook.

Thanks for any help you can give.

DJ

 

[Max]

Some thoughts ..

A sample construct is available at:
http://www.savefile.com/files/8745985
Comparing Values_displaying corresponding date.xls

Assume sample source table below is in sheet: X,
in cols A to F, data from row2 down

col A = stocks listing
cols B to F = dates in row1, projected values below

............ Date1 Date2 Date3 Date4 Date5 ...
Stock1 8 10 11 12 13
Stock2 13 18 18 19 20
Stock3 17 18 20 21 22
Stock4 13 17 18 18 26
Stock5 8 9 10 11 12
etc

And in sheet: Y,

The table below is set-up:
col A = stocks listing
col B = threshold values for each stock
col C = date threshold exceeded (to be returned from X)

..........ThresholdValue DateExceeded
Stock1 11 Date4
Stock2 17 Date2
Stock3 19 Date3
Stock4 15 Date2
Stock5 10 Date4

Put in C2:
=INDEX(X!$1:$1,,MATCH(B2,OFFSET(X!$1:$1,MATCH(A2,X!A:A,0)-1,),1)+1)
Format C2 as date to taste, copy down

Col C will return the required dates for each stock from row1 in X