Excel Formula with Logic Needed

[Panama1182]

I need an excel formula with proper logic to copy the value of the cell above given certain criteria. Cell A377-Cell A747 needs to equal cell A376. Cell A748 is a different name but should stay that way because Cell C748 reads "Department 000." Essentially I want a formula that can understand that anytime it reads "Department 000" in Column C then the name in Column A is correct. For every cell below "Department 000" through "All Department Num" the correct value in Cells A should be the name of the closest cell above them where Column C reads "Department 000."

 

[hagia_sofia]

Is this what you are looking for (you do not mention where to put the new data so I picked the column F):

=IF(C376="Department 000",A376,F375)

 

[Panama1182]

Is this what you are looking for (you do not mention where to put the new data so I picked the column F):

=IF(C376="Department 000",A376,F375)[/CODEI n
[/QUOTE]

 

[Joe4]

Not really sure what that reply is trying to say.
Did it work for you?

 

[Panama1182]

No it did not.

I need a formula in cell A5 to repeat the name in cell B4 until the name changes in B376. Once it changes, I want the new name to be repeated in cell A377 until the name changes again. The names in column B change every time "Department 000" appears in column D. Same range of departments repeated from "Department 000 - Department 969" and "All Department Num" as shown in screenshot. Whenever it does not show "Department 000" then it will be a blank in any cell in Column B.

 

[Cubist]

A few questions:
1) Which version of Excel are you using?
2) Do the rows have some values like you showed already in Col A or it's completely blank?

 

[Panama1182]

I am using Microsoft office professional plus 2019. The rows will be completely blank aside from the departments listed in column D.

 

[Cubist]

If I understand correctly, try this:

Book2
	A	B	C	D
4	A	A		Department 000
5	A			Department 001
6	A			Department 002
7	A			Department 003
8	A			Department 004
9	A			Department 005
10	A			Department 006
11	A			Department 007
12	A			Department 008
13	A			Department 009
14	A			Department 010
15	A			Department 011
16	A			Department 012
17	A			Department 013
18	B	B		Department 000
19	B			Department 001
20	B			Department 002
21	B			Department 003
22	B			Department 004
23	B			Department 005
24	B			Department 006
25	B			Department 007
26	B			Department 008
27	B			Department 009
28	B			Department 010
29	B			Department 011
30	B			Department 012
31	B			Department 013
Sheet7

Cell Formulas
Range	Formula
A4:A31	A4	=LOOKUP(2,1/($D$4:D4="Department 000"),$B$4:B4)

 

[Panama1182]

that worked perfectly! Thank you.

 

[Cubist]

that worked perfectly! Thank you.

You're welcome. Glad we can assist. Cheers.