Compare values, display date

D

DeejGCK

There is a threshhold value that I need to compare projected values to

When the projected value becomes > the threshhold value, I need to
display the date when that happens and if it doesn't happen in th
projected data then n/a.

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


Thanks for any help you can offer.

D
 
P

Peo Sjoblom

=INDEX(Date_Range,MATCH(TRUE,Projection_Range>Threshold,0))

could look like this with dates in A2:Z2 and projections in A3:Z3

Threshold value in sheet called summary B2

=INDEX(A2:Z2,MATCH(TRUE,A3:Z3>Summary!B2,0))


needs to be entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing Values, displaying corresponding date 1
comparing sheet to sheet and adding value 1
Comparing two spreadsheets 2
Excel VBA macro, search - accumulate - delete original 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Problem with formula for finding last greater than/less than or equal to value 2
Comparing a cell value with a range in a table and displaying a response 0
Macro for comparing columns and highlighting matching/differences 13

Top