Index Match I Think But Mind Gone Blank

[nehpets12]

I need a formula that will fill in the blank cells with the latest information.

Book4
	A	B	C	D	E
1	SeqNumber	Name	Department	CountsTheNumberOfEntries	ThisIsWhatINeedToSeeInBlankCells
2	1	Steve	Production	1
3	2	Steve		2	Production
4	3	Steve	Works	3
5	4	Paul	Sales	1
6	5	Steve		4	Production
7	6	Paul		2	Sales
8	7	John	Manufacture	1
9	8	John		2	Manufacture
10	9	Steve		5	Works
11	10	Paul		3	Sales
12
Sheet1

 

[DonkeyOte]

should C3 be Production? else I don't understand what you're trying to do.

 

[nehpets12]

Yes C3 Should Be Production
C6 Production
C7 Sales
C9 Manufacture
C10 Works
C11 Sales

 

[DonkeyOte]

well you could use (C3):

=INDIRECT("C" & MATCH(B3,$B$2:$b$11))

or

=INDEX($C$2:$C$11,MATCH(B3,$B$1:$b$11,0))

but either way if this is the first instance of the name then you will be stumped as you won't return a value in C.

 

[nehpets12]

I need C6 To Be Works and C10 To Be Works As The Last Entry For Steve In Cell C4 Is Works

Book4
	A	B	C	D	E
1	SeqNumber	Name	Department	CountsTheNumberOfEntries	ThisIsWhatINeedToSeeInBlankCells
2	1	Steve	Production	1
3	2	Steve	Production	2	Production
4	3	Steve	Works	3
5	4	Paul	Sales	1
6	5	Steve	Production	4	Works
7	6	Paul	Sales	2	Sales
8	7	John	Manufacture	1
9	8	John	Manufacture	2	Manufacture
10	9	Steve	Production	5	Works
11	10	Paul	Sales	3	Sales
12
Sheet1