How to find the correct value when considering two variables?

Good day all again.
Yeah, I'm busy programming again and I have hit another challenge I sadly can't solve...

What is it? Well... I am trying to get a list of pitstops, vertical list, into a list that shows the lapnumbers of the pitstops behind each driver. Some made no pitstops, some 3, some 1, most 2. With this double variable (starting number and number of pitstop) I get confused. I can work out the first pitstop correctly with an iferror formula combined with a vlookup, but with the second one it goes wrong when the driver made a third stop (then only the third shows up and not the second, resulting in first, third, third).

See attachment for how I would like to see the results. And yes, it is just filled in by hand. But my idea is: the more Excel does, the less mistakes there are made. So my question is: what formula(e) should I use to get the final result I desire (Col. E-L). So yeah, it might be that a driver stops 4 or 5 times...

Thanks in advance for reading, trying or solving. It's appreciated.

Kind regards,
Daniël.

In H4

==IF(COLUMNS($H$1:H$1)<=$G4,INDEX($C$4:$C$43,MATCH($E4,$A$4:$A$43,0)+COLUMNS($H1:H1)-1),"")

copy across and down

Originally Posted by Fluff13

How about
In G4 copied down

Formula:

Please Login or Register  to view this content.

and in H4 copied down & across

Formula:

Please Login or Register  to view this content.

The H4 formula needs to be confirmed with Ctrl Shift Enter before dragging down & across

That formula will result in the total number of stops, being the value calculated in column G. Sadly that was not what I was looking for. I am interested in how to get the laps (col. C) into col. G-L.

Originally Posted by JohnTopley

In H4

==IF(COLUMNS($H$1:H$1)<=$G4,INDEX($C$4:$C$43,MATCH($E4,$A$4:$A$43,0)+COLUMNS($H1:H1)-1),"")

copy across and down

I had to replace the , with ; and ajust the column letters, but sadly this is what I get for result... Did I do something wrong?

Yeah, seems like I made a mistake in both Fluff13's formulae and JohnTopley's formulae. Thanks, both are working now. I appreciate the effort and the thinking along.

Originally Posted by JohnTopley

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

I did. Just was waiting for your reply before closing. :-)