VLookup or Index or What?

[jordiejones]

Hey I've got a sheet in a workbook that I need to populate using named ranges from another (schedule sheet) w/in the same book. I have A1 as "week Number" and put the date in A2.
my goal is to populate the range below it (b1:w13) with the appropriate week from the schedule.
Each named ranges are Week1, Week2, Week3, Week4, Week5

 

[shemayisroel]

Hi,


Could you please provide some sample data along with your expected result(s)

Try using excel jeanie

http://www.excel-jeanie-html.de/index.php?f=1