VLookup (to be variable by month)

[andy2707]

Hey all,

If this is a duplicate post, then I apologise in advance, but I don't know what words I should be using to search for an answer.

Example Workbook attached.

I want to be able to select someone from the first drop down (D2) to populate the date below, but then be able to switch from month to month by using the second drop down (I2)

I am pretty sure I have overthought this and am now stumped.. Any help would be greatly appreciated.

[Shareez Saleem]

See the attached file, based on the period the values will change and for the name parameter, I have given 2 conditional formatting.

=IF(C$5="","",VLOOKUP($B6,INDIRECT("'"&TEXT($J$2,"Mmm")&"-"&RIGHT(YEAR($J$2),2)&"'!$A$3:$Z$17",TRUE),COLUMN(Summary!B$5),0))

Please review and revert if you need further assistance.

[wk9128]

Worksheet Summary, B6 cell formula , Drag down and accross