Worksheet names in If statements

  • Thread starter Thread starter J. Alex
  • Start date Start date
J

J. Alex

I have 42 rows on a summary worksheet. Then I have 42
individual worksheets that contain data. I have written an
IF statement to go to the first worksheet. What I am
looking for is a way to drag that if statement down and
increment the worksheet in the statement.
 
Hi
please post your current formula. Also explain if your worksheet names
have a naming convention
 
The worksheets have employee names

=IF('Jeremy Jones'!$G$3>84,IF('Jeremy Jones'!$G$4>84,IF
('Jeremy Jones'!$G$5>84," ","Red Flag"),"Red Flag"),"Red
Flag")
 
The INDIRECT Function is most likely what you need.

In A1 enter =INDIRECT("Sheet" & (ROW()) & "!E3")

Returns Sheet1!E3 data.

When copied down, A2 will reference Sheet2!E3, etc.

Wrap your IF statement around this.

Gord Dibben Excel MVP
 
Hi
one way:
if column A stores your employee names use the following formula in B1
=IF(ÍNDIRECT("'" & A1&"'!$G$3")>84,IF(INDIRECT("'" & A1 &
"'!$G$4")>84,IF
(INDIRECT("'" & A1 & "'!$G$5")>84," ","Red Flag"),"Red Flag"),"Red
Flag")
and copy this´down
 
Back
Top