Worksheet names in If statements

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.
 
F

Frank Kabel

Hi
please post your current formula. Also explain if your worksheet names
have a naming convention
 
G

Guest

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")
 
G

Gord Dibben

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
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Address Format changed after Migration 0
IF statement reference 1
Embed the same Excel multiple times 0
VLookup sum multiple matches 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Multiple IF statements, macro stops at first True 0
Formula: Counting Cells on Different Worksheets 3

Top