on tab: Weeks NQCQ I have a table as follows

Col A Col B Col C
Week CQ Week NQ Week
wk2 1Q10 Wk-12 Week 2
wk3 1Q10 Wk-11 Week 3
wk4 1Q10 Wk-10 Week 4
wk5 1Q10 Wk-9 Week 5
wk6 1Q10 Wk-8 Week 6
wk7 1Q10 Wk-7 Week 7
wk8 1Q10 Wk-6 Week 8
wk9 1Q10 Wk-5 Week 9
wk10 1Q10 Wk-4 Week 10
wk11 1Q10 Wk-3 Week 11
wk12 1Q10 Wk-2 Week 12
wk13 1Q10 Wk-1 Week 13
wk14 2Q10 Wk-13 Week 14


On tab "Week at a Glance", in cell B4 I will put in the current week, lets
say I input wk8, on the same tab, I need a formula to look at the table above
and insert the corresponding CQ Week in Col B (answer should be 1Q10 Wk-6).
I will need a similar formula in cell I4, that will grab the correct answer
from column C above.