Forum Discussion

martin1230's avatar
martin1230
Copper Contributor
Oct 23, 2020
Solved

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...
excel
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Oct 26, 2020

    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

martin1230's avatar
martin1230
Copper Contributor
Oct 26, 2020
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))
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 26, 2020

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

Resources