If a cell contains a certain text it inputs text on another spreadsheet

**thedonuttinz** · 08-26-2013, 10:23 PM

I'm trying to create a spreadsheet for my work scheduling. What I'm trying to do is for instance I have John James on column 1 Row 1 and he is scheduled to work which is identified as an O in column 3 row 1. If data contains O in a cell I want the data which contains John James in col 1 row 1 to appear on a separate excel sheet. I rather have it on a separate sheet but I can work with it being on the same sheet if that's the only possible way.

I'm a noob and really all I really know how to do formulas in excel is basic add multiply formulas. I hope I explained it right on what I am trying to do. Thanks in advance.

**FDibbins** · 08-26-2013, 11:11 PM

Hi and welcome to the forum

Im sure we can help you with this, but it would help if we could see what we are working with. I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**thedonuttinz** · 08-27-2013, 12:36 AM

Thanks. I've attached the SAMPLE file. Problem I know I will have is I have to make the Projection Sheet (Sheet 2) daily. Each day I make the projection sheet and print it out. As you can see John Smith works Sept 1 and shows up in the Projection sheet 2.

I found this:

=IF(B1="red",6,IF(B1="blue",7,0))

Works but I wouldn't know how to have the result to appear in Sheet 2. Another problem is having to enter each formula for each day but appear in Sheet 2 daily so Sept 1 would only show in the projection sheet.