Conditional XLOOKUP

[Mike111]

Hi

I have some more raw data that I'm trying to organise.

It shows Adam scoring 9 points (cell J3) and then 8 points in week 2 (u3)

I have about 20 weeks of data.


At the moment ,I'm using xlookup to put the data into the right cell, but as you can see for week 2 I'm having to line up the correct column each time for this to work.

However, I have the week number contained in the data , rows B and M

I would like to put all my data into rows A to J and it to check the week number before writing to rows 29 30 31

Could you help please

[6StringJazzer]

I'm not sure which part you want us to do. "I would like to put all my data into rows A to J" I'm going to assume you can do/have done that part. I'll give the formulas for the lower part.

I suggest to put your data on one sheet, and your summary formulas on another. Also, there is no need to repeat the headers each week for A:J. I have provided two new sheets with the solution.

You said you have 20 weeks so I showed 20 weeks in your summary even though the data is not all there. It will be populated as you add more weeks to the input data.

[Mike111]

Thank you. That’s done what I wanted

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking $A addreputationiconsmall.jpg below their profile in any of their posts.