Nov 29 2021 02:06 PM
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?
Nov 29 2021 02:40 PM
=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?