Lookup row, dependant on cell value?

[Simon]

I have a sheet, as per the example. I need to insert into column A the
quantities, depending on the value a specfic cell.

I.e if week 2 is entered, the column A should read, 12,5,2,3,3,3 and if Week
1 is entered 5,3,2,3,2,2 etc

I have looked at using HLOOKUP, however this does not replicate the
reference cell corrected unless each line is configured serperately.

What is the easiest way to acheive this. At the moment I need to select the
column manually, and replicate down the sheet, rather than just enter the
required week number into a cell, and let excel adjust automatically.

1 2 3 4 5
x Location 5 12 1 3 2
x Alabama 3 5 6 2 2
x Denver 2 2 3 4 2
x Boston 3 3 5 9 2
x New York 2 3 9 5 2
x Seattle 2 3 4 6 9



Week Number 2

 

[Pete_UK]

With your data set occupying B2:G7 and with the week number entered
into cell C9, enter this formula in A2:

=INDEX(C2:G2,C$9)

and copy down to A7.

Hope this is what you wanted.

Pete

 

[Simon]

Perfect!!

thanks

With your data set occupying B2:G7 and with the week number entered
into cell C9, enter this formula in A2:

=INDEX(C2:G2,C$9)

and copy down to A7.

Hope this is what you wanted.

Pete

 

[Pete_UK]

Thanks for the feedback, Simon.

Pete

Perfect!!

thanks