Xlookup accross and down

Hi, in the attached sheet I would like to have the column R values filled when I select the relevant month in the drop down in Q2 so that each location is shown next to the value for them for that specific month so for example location 1 for January would show £817,991 in the box and location 2 would show £344,747 if I then changed the month to Feb these values would update to show £57,259.37 and £24,132.29 respectively. Can someone help as I have trieda couple of things but not sure how best to do this?

Another option

Formula:

Please Login or Register  to view this content.

Another option

Cell R3 formula , Drag down

Formula:

Please Login or Register  to view this content.

Thanks everyone, al of these solutions work, although there is no guarantee the locations will always be in the same order as it is a monthly data set but have got what I need, thanks for the help, the nested XLOOKUP is the one I was trying to get to but couldn't

Glad to help & thanks for the feedback.

@moneypennie21 You're Welcome. Glad to help . Thank You for the feedback and rep.