change group of cells based on 1 cell value

[cc4mail]

The boss says make this work -

I have an employees 4 week days off table.

Based on the value (1 thru 7) of one cell on sheet1

days off are selected from a range of cells on sheet2 to populate a range of cells on sheet1.

How do I do this??? =(if A1=1, sheet2!B6:AC6,elseif A1=2...

Thanks...

 

[MisterC]

LOL - "The boss says make this work"

Look into VLOOKUP and HLOOKUP or CHOOSE.