Help using vlookup with "From" & "To" numbers

[ibenam]

I am trying to bring data in to the green cell based on 2 numbers (highlighted in yellow)

A user would change these numbers depending on the week he wanted the data for.

In the example shown the user would be returned 52.

Is there a simple way to achieve this?

Thanks

[DBY]

Hello
You could use SUMIFS, for example:

Please Login or Register  to view this content.

Ensure week no's are only entered once, else they will be added to the calculation.

DBY

[jewelsharma]

Values for Manchester is 13 for all weeks. You need to clarify which one is selected & exactly based on what?

[ibenam]

Hello
You could use SUMIFS, for example:

Please Login or Register  to view this content.

Ensure week no's are only entered once, else they will be added to the calculation.

DBY

Works pefectly - very clever. Thanks!

[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 on the star icon below their name.