HOW TO ADD "AT NEXT CHANGE TO VLOOKUP

[JuicyMusic]

Hi Guru's, I've tried all kinds of combinations and I am unable to get the result I need trying to combine other formulas to the existing VLOOKUP. Please assist.

I don't know exactly how to write what I need, but I will try. I need the results of the VLOOKUP to be consistent until the "next change" of the Project Manager name. If there is a good result above, I would like that same result to be copied down UNTIL the "next change" of the name of the Project Manager.

I think the spreadsheet will help so much. THANK YOU SO MUCH.

NEED TO ADJUST VLOOKUP FORMULA 7.8.22.xlsx
	E	F	G	H
1
2
3	THIS IS THE RESULT I NEED IN THIS GREY COLUMN VLOOKUP FORMULA IN THIS COLUMN
4	In column E: From tab named "Office Earnings"	In column F: DATA ROWS From tab named "Office Earnings"		In column B: From tab named "Project Managers", List target for Vlookup
5	Project Manager: 11111	Project Manager: 11111		Project Manager: 11111
6	Project Manager: 11111	JD		Project Manager: 654654
7	Project Manager: 11111	JD		Project Manager: 4148484
8	Project Manager: 11111	JD		Project Manager: 789789
9	Project Manager: 11111	JD		Project Manager: 1471965
10	Project Manager: 11111	JD
11	Project Manager: 11111	JD
12	Project Manager: 11111	JD
13	Project Manager: 11111	JD
14	Project Manager: 11111	JD
15	Project Manager: 11111	JD
16	Project Manager: 11111	JD
17	Project Manager: 654654	Project Manager: 654654
18	Project Manager: 654654	JD
19	Project Manager: 654654	JD
20	Project Manager: 654654	JD
21	Project Manager: 654654	JD
22	Project Manager: 654654	JD
23	Project Manager: 654654	JD
24	Project Manager: 654654	JD
25	Project Manager: 654654	JD
26	Project Manager: 654654	JD
27	Project Manager: 654654	JD
28	Project Manager: 654654	JD
29	Project Manager: 4148484	Project Manager: 4148484
30	Project Manager: 4148484	JD
31	Project Manager: 4148484	JD
32	Project Manager: 4148484	JD
33	Project Manager: 4148484	JD
34	Project Manager: 4148484	JD
35	Project Manager: 4148484	JD
36	Project Manager: 4148484	JD
37	Project Manager: 4148484	JD
38	Project Manager: 4148484	JD
39	Project Manager: 4148484	JD
40	Project Manager: 4148484	JD
41	Project Manager: 789789	Project Manager: 789789
42	Project Manager: 789789	JD
43	Project Manager: 789789	JD
44	Project Manager: 789789	JD
45	Project Manager: 789789	JD
46	Project Manager: 789789	JD
47	Project Manager: 789789	JD
48	Project Manager: 789789	JD
49	Project Manager: 789789	JD
50	Project Manager: 789789	JD
51	Project Manager: 789789	JD
52	Project Manager: 789789	JD
53	Project Manager: 1471965	Project Manager: 1471965
54	Project Manager: 1471965	JD
55	Project Manager: 1471965	JD
56	Project Manager: 1471965	JD
57	Project Manager: 1471965	JD
58	Project Manager: 1471965	JD
59	Project Manager: 1471965	JD
60	Project Manager: 1471965	JD
61	Project Manager: 1471965	JD
62	Project Manager: 1471965	JD
63	Project Manager: 1471965	JD
64	Project Manager: 1471965	JD
Sheet1

Cell Formulas
Range	Formula
E41	E41	=+H8
F41,F53	F41	=+E41
E53	E53	=+H9

 

[bebo021999]

Add this formula in E5 then drag down

=IF(COUNTIF('Project Managers'!B:B,F5),F5,E4)