Vlookup Bottom To Top

[nehpets12]

Sorry my last posting was not very clear. I need a formula that looks for the last entry against a name and returns the department.

It needs something like vlookup but needs to start at the bottom and work up.

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

 

[attc]

I found it easiest to enter an extra column to get the effect you want:

Book1
	A	B	C	D	E
1	SeqNumber	Name	Department-partial	Department-complete	Index1
2	1	Steve	Production	Production	Steve1
3	2	Steve		Production	Steve2
4	3	Steve	Works	Works	Steve3
5	4	Paul	Sales	Sales	Paul1
6	5	Steve		Works	Steve4
7	6	Paul		Sales	Paul2
8	7	John	Manufacture	Manufacture	John1
9	8	John		Manufacture	John2
10	9	Steve		Works	Steve5
11	10	Paul		Sales	Paul3
Sheet1