SOLVED

Index Lookup Match Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1812574%22%20slang%3D%22en-US%22%3EIndex%20Lookup%20Match%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1812574%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20at%20a%20loss%2C%20been%20trying%20to%20figure%20out%20the%20formula%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20need%20to%20get%20the%20time%20that%20John%20and%20Eddy%20spent%20on%20their%20lunch%20and%20break%20and%20display%20it%20on%20the%20table%20on%20the%20right%20side.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help%20me%20with%20this.%20I%20have%20also%20attached%20the%20file.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture1.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228730iBD89A27B06DF0908%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture1.PNG%22%20alt%3D%22Capture1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1812574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1812756%22%20slang%3D%22de-DE%22%3ESubject%3A%20Index%20Lookup%20Match%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1812756%22%20slang%3D%22de-DE%22%3EJust%20as%20an%20approach%2C%20maybe%20it%20fits%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%20%3DSUMIF(F9%3AF25%2C%22Break%201%22%2CH9%3AH25)%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Wish%20you%20a%20nice%20day.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1818592%22%20slang%3D%22en-US%22%3EBetreff%3A%20Index%20Lookup%20Match%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3Bhi%20and%20thank%20you%20for%20the%20reply%2C%20I%20forgot%20to%20tell%20that%20I%20get%20the%20report%20everyday%20and%20everyday%20the%20report%20changes%20like%20the%20cells%20of%20Break%201%20and%20Lunch%20almost%20always%20change%2C%20so%20what%20I%20need%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1%3A%20Look%20for%20the%20name%3C%2FP%3E%3CP%3E2%3A%20Then%20look%20for%20the%20Break%201%20Cell%20and%20get%20the%20value%3C%2FP%3E%3CP%3E3%3A%20look%20for%20the%20Lunch%20Cell%20then%20get%20the%20value%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20formula%20kinda%20like%20requires%20the%20Index%2C%20Match%20and%20Lookup%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1818625%22%20slang%3D%22en-US%22%3EBetreff%3A%20Index%20Lookup%20Match%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818625%22%20slang%3D%22en-US%22%3Ekinda%20like%20this%3CBR%20%2F%3E%3DINDEX(INDEX(G%3AG%2CMATCH(AK13%2CA%3AA%2C0))%3AQ500%2CMATCH(%22Break%201%22%2CINDEX(A%3AA%2CMATCH(AK13%2CA%3AA%2C0))%3AA500%2C0))%3C%2FLINGO-BODY%3E
Highlighted
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.

Capture1.PNG

4 Replies
Highlighted
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)
Highlighted

@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

Highlighted
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))
Highlighted
Best Response confirmed by martin1230 (Occasional Contributor)
Solution

@martin1230 

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.

 

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