• 467K Members
• 10.8K Online
• 565K Conversations

Is it possible to enter a value from column A if there is a value in column C into a different sheet

Occasional Contributor

Is it possible to enter a value from column A if there is a value in column C into a different sheet

I'm trying to make a work schedule. I have a spreadsheet with all shifts and a calendar style. I'm trying to find a formula to enter values into the calendar.

This is what it should look like, I've manually entered values into the calendar spreadsheet. For instance, when I enter an 8 into C3 on the top spreadsheet, I want KL to be automatically inserted into B5 on the lower spreadsheet. Is there a formula that I could enter to accomplish this?

6 Replies

Re: Is it possible to enter a value from column A if there is a value in column C into a different s

@chescott80 , what is the formal logic behind, why in B5 and not in C5 or B6? Same for others. And layout for Monday is fully different from one for Sunday., what is the logic for this?

Re: Is it possible to enter a value from column A if there is a value in column C into a different s

This is just how our shifts are, weekend vs weekday. I will enter a formula for each cell on the calendar. I can't change the setup for the calendar, this is what employees are used to looking at...the spreadsheet has the actual shifts to schedule. I want to cut down on errors of manually transferring data from the spreadsheet to the calendar.
Highlighted

Re: Is it possible to enter a value from column A if there is a value in column C into a different s

In column C, the 8 (for 8 hr shift) could be anywhere down the column, not necessarily in the KL row...where ever the 8 is the corresponding initials need to go into B5 on the calendar spreadsheet. In column D, the corresponding initials would be entered into C5 on the calendar.

Re: Is it possible to enter a value from column A if there is a value in column C into a different s

So, logics for the weekday and weekend is different. If for weekend initials for the 8 in second column (C) goes into B5 (I guess next column into C5, etc.), when for the Monday initials for the 8 in second column for the day are in F4, not in E5 if do that similar to Sunday.

And do you have exactly the same number of columns for every day?

Re: Is it possible to enter a value from column A if there is a value in column C into a different s

@Sergei Baklan Here is an example of a full week, both spreadsheet and calendar

So, Column B=B9, C=B5, D=C5, E=D5, F=B6, G=C6, H=D9, I=F4, J=G4, K=F5, L=F6, M=F7, N=F8, O=G8.  Weekdays have same shifts, Weekends have same shifts.

Re: Is it possible to enter a value from column A if there is a value in column C into a different s

I'm using excel 2013, so I can't use the IFS function
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies