Want to lookup value

[Alpacino]

Hi
I have a macro that extracts data from another workbook. Problem is the dads is in week numbers and the workbook say book2 only needs a max pf 4/5 weeks at a time.
Eg half a year
1.2.3.4.5
6.7.8.9
10.11.12.13
14.15.16.17.18.
19.20.21.22
23.24.25.26

Because I only need a max of either 4 weeks or 5 weeks at a time it not as simple as adding to another column for each week.
Is there any way in vba to say something like,
If week no is 24 number is 2 or week no is 18 no is 5 so on??

Thanks
Alan

 

[texasalynn]

It's not really clear what you need here. So if the workbook have 4 weeks, then what needs to happen. You say 4/5 weeks for a macro you need a definite determination in order for it to run based on that factor.