Matching Data

[JasonV]

I have time in 1 minute intervals in column C, and want to match temperature
data in 10 minute intervals in column J - corresponding times are in col I.
trying lots of diff formula combos, but cant get it to work. There are
thousands of data points. Any ideas?
samples:

=IF(C4=LOOKUP(I$4,C$4:C$1400,I$4:I$1400),J4,"")
or
=IF(C14=LOOKUP(I$4:I$1400,C$4:C$1400,I$4:I$1400),J14,"")
or
=IF(C41=OR(I41:I184),LOOKUP(C41,$I$4:$I$147,$J$4:$J$147),"")

 

[JasonV]

This is the closest i've gotten:

=IF(C4=LOOKUP(C4,I$4:I$1299,I$4:I$1299),LOOKUP(C4,I$4:I$1299,J$4:J$1299),"")
I was putting in arbitrary numbers for the list in the formulas below. above
is the actual list

 

[Sandy Mann]

If I follow you correctly your formula is trying to match the Temperature in
Column I with the time in Column C. Try:

=IF(C4=LOOKUP(C4,I$4:I$1299),LOOKUP(C4,I$4:I$1299,J$4:J$1299),"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

Even then you may have problems if you are entering the times by dragging
down on the fill handle the times will look correct but there may be small
errors in the underlying numbers that will prevent the comparison being
TRUE. If it still does not work try manually entering the matching time and
see if it then works.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[JasonV]

I got this to work, but I had to change the range for each specific day
because of repeats in times. I was going to try and do a day and time check
but decided it was too complicated for the task at hand...

This works:
=IF(C4=LOOKUP(C4,I$4:I$147,I$4:I$147),LOOKUP(C4,I$4:I$147,J$4:J$147),"")

- Jason