SOLVED

Index Lookup Match Formula

Occasional Contributor

Index Lookup Match Formula

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

Betreff: Index Lookup Match Formula

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

Wish you a nice day.

Nikolino
I know I don't know anything (Socrates)

Betreff: Index Lookup Match Formula

@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

Betreff: Index Lookup Match Formula

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)
Solution

Betreff: Index Lookup Match Formula

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

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.

Nikolino

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