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%3CLINGO-SUB%20id%3D%22lingo-sub-1819098%22%20slang%3D%22de-DE%22%3ESubject%3A%20Index%20Lookup%20Match%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1819098%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F806400%22%20target%3D%22_blank%22%3E%40martin1230%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20try%20it.%3CBR%20%2F%3EI%20am%20almost%20certain%20that%20there%20is%20a%20mistake%20somewhere%20...%20But%20I%20don't%20have%20the%20time%20to%20take%20care%20of%20it%20anymore.%3C%2FP%3E%3CP%3Eplease%20excuse%20me%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%20(the%20coolest%20invention%20since%20chocola...%20Uh...%20Microsoft!%20%3A-)))%3C%2FP%3E%3CP%3EAnd...Please%20keep%20asking%20here%20-%20I%20just%20taught%20myself%20Excel%20with%20the%20help%20of%20this%20forum...%20Nearly%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E
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
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)

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