Help on returning value in the same row

[jarout]

I think my problem might have a really simple way to be solved, but I'm having a hard time finding the best function option to be applied. Here we go: On cell U4 I have a "=MIN" function set that gives me the lowest value from K5:K51. "K" column shows temperature values, and "C" column the time they have been registered. Since cell U4 returns me the lowest value, I am trying to set the cell besides this one (V4) to return the time when it happened. Basically I want to cell V4 be able to search, depending on U4 value, the value of the cell two rows to the left.

As you guys can see, I am really newbie in it and I'm really clueless on this one. If anyone would help me I'd be very grateful! I figured a picture of it would make it easier. I'm also using a portuguese office pack, but it shouldnt make a big difference. Thanks in advance!

excel.png

[Mazzaropi]

jarout, Good evening.

Please, next time attach a sample of your Excel file, not a Photo of it.
It´s easier for people to help you.

Of course there some ways to do what you want.
Here you are one of it.

V4 --> =SUMPRODUCT(($K$4:$K$1000=U4)*($B$4:$B$1000=P4)*($C$4:$C$1000))

Adapt the range to the reality of your data.

Is this what you want?
I hope it helps.

[jarout]

Thanks Mazzaropi! I think I said something wrong when I explained it, I apologize. I tried to adapt changing the ranges in the formula and it came out like this: =SUMPRODUCT(($K$5:$K$52=U4)*($B$5:$B$52=P4)*($C$5:$C$52)). However it really didnt show me the value I wanted. I'm attatching my worksheet now, maybe it'll help better! As I said, U4 gives me the lowest value from K5:K52 range. What I want is V4 to check where the value in U4 came from (in this case it came from K40), and then return the value of eight rows to the left (which would be C40).

[jarout]

I reviewed the formula here Mazzaropi and it worked just fine! I was typing it incorrectly... My bad. Thank you so much for your help!

[Mazzaropi]

You´re welcome.

I feel happy to help you.

Have a nice day.

[Tony Valko]

If you're using Excel 2007 as your profile indicates then you can use the more efficient SUMIFS function:

=SUMIFS($C$4:$C$1000,$K$4:$K$1000,U4,$B$4:$B$1000,P4)