Index Lookup Match Formula

Occasional Contributor

Hi, I'm at a loss, been trying to figure out the formula for this.


Basically I need to get the time that John and Eddy spent on their lunch and break and display it on the table on the right side.


I hope someone can help me with this. I have also attached the file.


4 Replies
Just as an approach, maybe it fits
=SUMIF(F9:F25,"Break 1",H9:H25)

Wish you a nice day.

I know I don't know anything (Socrates)

@Nikolino hi and thank you for the reply, I forgot to tell that I get the report everyday and everyday the report changes like the cells of Break 1 and Lunch almost always change, so what I need is:


1: Look for the name

2: Then look for the Break 1 Cell and get the value

3: look for the Lunch Cell then get the value


So the formula kinda like requires the Index, Match and Lookup

kinda like this
=INDEX(INDEX(G:G,MATCH(AK13,A:A,0)):Q500,MATCH("Break 1",INDEX(A:A,MATCH(AK13,A:A,0)):A500,0))
best response confirmed by martin1230 (Occasional Contributor)


Please try it.
I am almost certain that there is a mistake somewhere ... but I don’t have the time to take care of it anymore.

please excuse me in advance.


I wish you continued success with Excel (the coolest invention since chocola... uh ... Microsoft! :-)))

And...Please  keep asking here - I just taught myself Excel with the help of this forum...nearly


I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here