Cantrecallmyusername
Board Regular
- Joined
- May 24, 2021
- Messages
- 50
- Office Version
- 365
- Platform
- Windows
HI there,
I have a data file where I am looking to return the title for a person. The raw file is quite large and covers a long time period so for certain people they have multiple titles as they have been promoted.
Using Excel I would like to return the most senior title for each person where there is multiple values. Using a basic vlookup it returns the first value.
=VLOOKUP(A2,$A:$B,2,0)
Is there a formula that you could suggest that will find the last hit in the column for a vlookup?
It is possible to combine a number of IF statements with the vlookup formulas but there are 26 titles possible and I would like to stay clear of this.
In the below sample I would like Senior Manager 1 to be retuned for Employee. I will always want the last value in column B to be returned also for the employee.
FYI - there will be lots of employees in column A and more roles in column B
I have a data file where I am looking to return the title for a person. The raw file is quite large and covers a long time period so for certain people they have multiple titles as they have been promoted.
Using Excel I would like to return the most senior title for each person where there is multiple values. Using a basic vlookup it returns the first value.
=VLOOKUP(A2,$A:$B,2,0)
Is there a formula that you could suggest that will find the last hit in the column for a vlookup?
It is possible to combine a number of IF statements with the vlookup formulas but there are 26 titles possible and I would like to stay clear of this.
In the below sample I would like Senior Manager 1 to be retuned for Employee. I will always want the last value in column B to be returned also for the employee.
FYI - there will be lots of employees in column A and more roles in column B
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Employee | Title | Week | ||
2 | Donald Duck | Manager | 15/07/2022 | ||
3 | Donald Duck | Manager | 15/07/2022 | ||
4 | Donald Duck | Manager 1 | 22/07/2022 | ||
5 | Donald Duck | Manager | 15/07/2022 | ||
6 | Donald Duck | Manager 1 | 05/08/2022 | ||
7 | Donald Duck | Manager 1 | 22/07/2022 | ||
8 | Donald Duck | Manager | 15/07/2022 | ||
9 | Donald Duck | Manager | 15/07/2022 | ||
10 | Donald Duck | Manager 1 | 22/07/2022 | ||
11 | Donald Duck | Manager | 15/07/2022 | ||
12 | Donald Duck | Manager 1 | 22/07/2022 | ||
13 | Donald Duck | Manager | 15/07/2022 | ||
14 | Donald Duck | Manager | 15/07/2022 | ||
15 | Donald Duck | Manager 1 | 09/09/2022 | ||
16 | Donald Duck | Manager | 15/07/2022 | ||
17 | Donald Duck | Manager 1 | 22/07/2022 | ||
18 | Donald Duck | Manager 1 | 09/09/2022 | ||
19 | Donald Duck | Manager | 15/07/2022 | ||
20 | Donald Duck | Manager | 15/07/2022 | ||
21 | Donald Duck | Manager | 15/07/2022 | ||
22 | Donald Duck | Manager | 22/07/2022 | ||
23 | Donald Duck | Manager | 15/07/2022 | ||
24 | Donald Duck | Manager | 15/07/2022 | ||
25 | Donald Duck | Manager | 15/07/2022 | ||
26 | Donald Duck | Manager | 15/07/2022 | ||
27 | Donald Duck | Manager | 15/07/2022 | ||
28 | Donald Duck | Manager | 15/07/2022 | ||
29 | Donald Duck | Manager | 15/07/2022 | ||
30 | Donald Duck | Manager | 15/07/2022 | ||
31 | Donald Duck | Manager | 22/07/2022 | ||
32 | Donald Duck | Manager | 22/07/2022 | ||
33 | Donald Duck | Manager | 15/07/2022 | ||
34 | Donald Duck | Manager | 15/07/2022 | ||
35 | Donald Duck | Senior Manager | 15/07/2022 | ||
36 | Donald Duck | Senior Manager | 22/07/2022 | ||
37 | Donald Duck | Senior Manager | 22/07/2022 | ||
38 | Donald Duck | Senior Manager | 15/07/2022 | ||
39 | Donald Duck | Senior Manager | 15/07/2022 | ||
40 | Donald Duck | Senior Manager | 15/07/2022 | ||
41 | Donald Duck | Senior Manager | 15/07/2022 | ||
42 | Donald Duck | Senior Manager | 15/07/2022 | ||
43 | Donald Duck | Senior Manager | 15/07/2022 | ||
44 | Donald Duck | Senior Manager | 11/11/2022 | ||
45 | Donald Duck | Senior Manager | 15/07/2022 | ||
46 | Donald Duck | Senior Manager | 15/07/2022 | ||
47 | Donald Duck | Senior Manager | 15/07/2022 | ||
48 | Donald Duck | Senior Manager | 11/11/2022 | ||
49 | Donald Duck | Senior Manager | 15/07/2022 | ||
50 | Donald Duck | Senior Manager | 15/07/2022 | ||
51 | Donald Duck | Senior Manager | 15/07/2022 | ||
52 | Donald Duck | Senior Manager | 11/11/2022 | ||
53 | Donald Duck | Senior Manager | 15/07/2022 | ||
54 | Donald Duck | Senior Manager | 15/07/2022 | ||
55 | Donald Duck | Senior Manager | 15/07/2022 | ||
56 | Donald Duck | Senior Manager | 11/11/2022 | ||
57 | Donald Duck | Senior Manager | 22/07/2022 | ||
58 | Donald Duck | Senior Manager | 15/07/2022 | ||
59 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
60 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
61 | Donald Duck | Senior Manager 1 | 11/11/2022 | ||
62 | Donald Duck | Senior Manager 1 | 22/07/2022 | ||
63 | Donald Duck | Senior Manager 1 | 22/07/2022 | ||
64 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
65 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
66 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
67 | Donald Duck | Senior Manager 1 | 11/11/2022 | ||
68 | Donald Duck | Senior Manager 1 | 12/08/2022 | ||
69 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
70 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
71 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
72 | Donald Duck | Senior Manager 1 | 11/11/2022 | ||
73 | Donald Duck | Senior Manager 1 | 22/07/2022 | ||
74 | Donald Duck | Senior Manager 1 | 22/07/2022 | ||
75 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
76 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
77 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
78 | Donald Duck | Senior Manager 1 | 11/11/2022 | ||
79 | Donald Duck | Senior Manager 1 | 22/07/2022 | ||
80 | Donald Duck | Senior Manager 1 | 22/07/2022 | ||
81 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
82 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
83 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
84 | Donald Duck | Senior Manager 1 | 11/11/2022 | ||
85 | Donald Duck | Senior Manager 1 | 22/07/2022 | ||
86 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
87 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
88 | Donald Duck | Senior Manager 1 | 15/07/2022 | ||
89 | Donald Duck | Senior Manager 1 | 11/11/2022 | ||
Sheet1 |