Matching Data

J

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),"")
 
J

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
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
J

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
 
Top