Forum Discussion
Need help with an IF formula that pulls data from multiple Worksheets
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 dat...
=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?