if functions

  • Thread starter Thread starter Chubby
  • Start date Start date
C

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.
 
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
 
Hi
not really sure what number you enter in B5. You may provide some more
examples and the expected result for each example
 
Back
Top