Consulting the geniuses here! Formula to pull data into cell based off of other specific data.

[IsItFriday]

Hello all,

I recently started a new job and have not had to use much excel in a while. I am completely rusty and feel like I have no idea what I am doing.

I'm building a template to help track hours and where the hours are being allocated to.
Not sure what formula to even be using, so after some online searching I've decided to ask you all!

Below is some sample data I have put together.

I am trying to pull data into the column labeled "Flagged for Error".
Specifically the Org_Code number is what I want pulled in but I only want it to pull in if incorrect.
I have a specific list of departments that should always start with a 1.
Pumper Route #12 being one of them.
I know I can create a new tab and have all the department name/descriptions in that tab but I am just completely lost on what formula to use.

Any help on this would be immensely appreciated!

EmployeeNumber	LastName	FirstName	Org_Code	Org_Desc	Flagged for Error	EarningCode	HoursAmount	Total	Sum of all Hours
125​	White	Kira	40016	Finance		PTO​	13:30:00​	13.5​	13.5​
440​	Boyd	Billy	40021	Production Operations		OT​	5:00:00​	15​	15​
440​	Boyd	Billy	40021	Production Operations		Reg​	10:00:00​	10​	15​
282​	Johnson	Jacob	10019	Production Ops/LOE		OT​	59:00:00​	59​	138​
282​	Johnson	Jacob	10019	Production Ops/LOE		Reg​	79:00:00​	79​	138​
317​	Smith	Kelly	40000	Accounting		OT​	3:15:00​	3.25​	95.5​
317​	Smith	Kelly	40000	Accounting		Reg​	92:15:00​	92.25​	95.5​
394​	O'Neal	Jason	40021	Production Operations		PTO​	13:00:00​	13​	13​
215​	Woods	Scott	40033	Pumper Route #12		OT​	38:00:00​	38​	46​
215​	Woods	Scott	40033	Pumper Route #12		Reg​	8:00:00​	8​	46​

 

[Michael M]

I can't offer any help right now, but in you dataset provided, what would appear in column "Flagged for error"

 

[IsItFriday]

I can't offer any help right now, but in you dataset provided, what would appear in column "Flagged for error"

Specifically the Org_Code number is what I want pulled in but I only want it to pull in if incorrect.

 

[Michael M]

Can you post the samples that would appear in that column please ??

 

[IsItFriday]

Can you post the samples that would appear in that column please ??

For Scott Wood it would pull in 40033 as flagged for error.

 

[Michael M]

Assuming your data starts in Column "A"
Try using

=IF(ISNUMBER(SEARCH("1",E2)),D2,"")