vlookup with variables

Hey everyone,

I've got two worksheets A & B with:
A - the source of data
B - the destination sheet

I'm trying to put together a code with a vlookup at it's core that should:
1. compare column "F" from worksheet "B" with column "G" from worksheet "A"
2. assign the correspondént values in column "P" in worksheet "B" as they appear in the correspondent reporting month from worksheet "A".

In this case the month is October.
However it would be great if the code would be able to determine which monthly values need to be assigned in worksheet "B" by comparing the monthly headlines from worksheet "A" with the month selection in worksheet "list".
Where the corespondent month has been found in worksheet "A", the code should pick the column index from the cell above.

Please see attachment and many thanks for your support!

regards,

thanks for your reply nigelbloomy,

yes the formula makes sense - however for some reason it does not work. I'm getting a #NV in P2.
Could you please have a look? thanks!

regards

sorry - I had a typo in my formula

It works perfectly after correction!!!