Hello
Not getting what you need exactly...
As far I have understood you need to lookup for the current week number and get the corresponding value...
This may help
=VLOOKUP(WEEKNUM(TODAY()),A:B,2,FALSE)

Sorry if this is not what you need...