[SOLVED] VLOOKUP with Drop Down Selection, unsorted data

[kaj]

Hi All
I have data in a history sheet by year and week no, approx 225 entries per week. In a another sheet (Week Data) the user can select a week no and year from drop downs and the sheet is populated which in turns updates charts. Works fine if I select the first set of data, which happens to be at the top of the history, but when I select another week and/or year I get duplicated data.
Can not be a pivot table or use code on this occassion.

This is my formula in Week Data B8 can anyone help?

My Formula:

=IF($A8>$A$7,"",VLOOKUP($A8,'History Data'!$A8:$X5080,COLUMNS('Weekly Data'!$B8:C8),0))

There is probably a simple answer, but this workbook has pickled my brain, I did not create it and have already had to clean up.

Thanks