Need help with an IF formula that pulls data from multiple Worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3016006%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20an%20IF%20formula%20that%20pulls%20data%20from%20multiple%20Worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3016006%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20have%20an%20Excel%20spreadsheet%20that%20has%205%20worksheets.%20Worksheet%20%231%20is%20a%20summary%2Fcombination%20of%20values%20from%20Worksheets%202-5.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20I'm%20trying%20to%20get%20C1%20to%20show%2C%20based%20on%20a%20formula%20to%20pull%20data%20from%20C1%20on%20Worksheets%202-5.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EExample%20%231%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet1%3A%26nbsp%3B%20%22W4-Yes%20W5-Yes%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet2%3A%20%22No%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet3%3A%20%22No%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet4%3A%20%22Yes%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet5%3A%20%22Yes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20%232%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet1%3A%26nbsp%3B%20%22W2-Yes%20W3-Yes%20W4-Yes%20W5-Yes%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet2%3A%20%22Yes%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet3%3A%20%22Yes%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet4%3A%20%22Yes%22%3C%2FP%3E%3CP%3ECell%20C1%20on%20Worksheet5%3A%20%22Yes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20layman%20terms%2C%20having%20the%20C1%20formula%20on%20Worksheet1%20be%20something%20similar%20to%20(but%20coded%20correctly)%20%3DIF('Worksheet1'!C1%3D%22Yes%22%2C%22W1-Yes%2C%22%22)%20or%20%3DIF('Worksheet2'!C1%3D%22Yes%22%2C%22W2-Yes%2C%22%22)%20or%20%3DIF('Worksheet3'!C1%3D%22Yes%22%2C%22W3-Yes%2C%22%22)%20or%20%3DIF('Worksheet4'!C1%3D%22Yes%22%2C%22W4-Yes%2C%22%22)%20or%20%3DIF('Worksheet5'!C1%3D%22Yes%22%2C%22W5-Yes%2C%22%22)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20figure%20out%20the%20formula%20for%20C1%20on%20Worksheet%201%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3016006%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3016057%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20an%20IF%20formula%20that%20pulls%20data%20from%20multiple%20Worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3016057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1232904%22%20target%3D%22_blank%22%3E%40JRink99%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCONCATENATE(IF(Worksheet2!C1%3D%22Yes%22%2C%22W2-Yes%22%2C%22%22)%2C%22%20%22%2CIF(Worksheet3!C1%3D%22Yes%22%2C%22W3-Yes%22%2C%22%22)%2C%22%20%22%2CIF(Worksheet4!C1%3D%22Yes%22%2C%22W4-Yes%22%2C%22%22)%2C%22%20%22%2CIF(Worksheet5!C1%3D%22Yes%22%2C%22W5-Yes%22%2C%22%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 I have an Excel spreadsheet that has 5 worksheets. Worksheet #1 is a summary/combination of values from Worksheets 2-5. 

 

This is what I'm trying to get C1 to show, based on a formula to pull data from C1 on Worksheets 2-5.


Example #1

Cell C1 on Worksheet1:  "W4-Yes W5-Yes"

Cell C1 on Worksheet2: "No"

Cell C1 on Worksheet3: "No"

Cell C1 on Worksheet4: "Yes"

Cell C1 on Worksheet5: "Yes

 

Example #2

Cell C1 on Worksheet1:  "W2-Yes W3-Yes W4-Yes W5-Yes"

Cell C1 on Worksheet2: "Yes"

Cell C1 on Worksheet3: "Yes"

Cell C1 on Worksheet4: "Yes"

Cell C1 on Worksheet5: "Yes

 

 

 

In layman terms, having the C1 formula on Worksheet1 be something similar to (but coded correctly) =IF('Worksheet1'!C1="Yes","W1-Yes,"") or =IF('Worksheet2'!C1="Yes","W2-Yes,"") or =IF('Worksheet3'!C1="Yes","W3-Yes,"") or =IF('Worksheet4'!C1="Yes","W4-Yes,"") or =IF('Worksheet5'!C1="Yes","W5-Yes,"") 

 

Can someone help me figure out the formula for C1 on Worksheet 1?

 

1 Reply

@JRink99 

=CONCATENATE(IF(Worksheet2!C1="Yes","W2-Yes","")," ",IF(Worksheet3!C1="Yes","W3-Yes","")," ",IF(Worksheet4!C1="Yes","W4-Yes","")," ",IF(Worksheet5!C1="Yes","W5-Yes",""))

 

Is this what you are looking for?