if functions

[Chubby]

I am trying to figure out how to set up a vlookup for the
following:

On sheet 1, if cell c1 = 1 then cell a1= "sheet 2"A2
if cell c1 = 2 then cell a1= "sheet 2"B2
if cell c1 = 3 then cell a1= "sheet 2"C2

etc etc with cell c1 going up to 31. I believe that
vlookup is what to use but can't get it to work. On sheet
2 I have days from 1 to 31 going across the columns and
under the days I have the day of the week. Sheet 1 is a
report form that when I enter the days date 1 for eg the
actual day will automatically be assigned. Because of
the nested arugment restriction I am now using 4
different forms to make a report that could be on one.
Appreciate any help you can give me.

 

[Frank Kabel]

Hi
try the following formula in A1:
=OFFSET('sheet2'!$A$2,0,C1-1)

 

[JE McGimpsey]

One way:

A1: =INDEX('Sheet 2'!2:2,C1)

 

[chubby]

Hi, tried that but it didn't work. Here are the actual
cell references.

In cell F6 in 'Report' sheet I need a formula that will
return the content in cell B6 located in 'Summary' sheet
if I enter the same number located in B5 'Summary' sheet.

Report sheet Summary sheet

A.... F

 

[Frank Kabel]

Hi
not really sure what number you enter in B5. You may provide some more
examples and the expected result for each example