Combo Box dropdown generated listing all values in column B based on Matches for Column A

[jmcease]

I would like to populate the Combo Boxes in Colum D from data in Column B based on matches for specific values in Column A. I was able to do dropdown lists based on OffSet, but that wont work in a combo box and would like a combo box as they are always visible.
=OFFSET(B1,MATCH("Dinner-In-Home Meal",A2:A40,0),0,COUNTIF(A2:A40,"Dinner-In-Home Meal"),1)

=OFFSET(B1,MATCH("Personal Care",A2:A40,0),0,COUNTIF(A2:A40,"Personal Care"),1)

=OFFSET(B1,MATCH("Personal Care/Evenings",A2:A40,0),0,COUNTIF(A2:A40,"Personal Care/Evenings"),1)

=OFFSET(B1,MATCH("Personal Care/Weekends",A2:A40,0),0,COUNTIF(A2:A40,"Personal Care/Weekends"),1)

=OFFSET(B1,MATCH("ADC-Full Day w/NISP Meal",A2:A40,0),0,COUNTIF(A2:A40,"ADC-Full Day w/NISP Meal"),1)

=OFFSET(B1,MATCH("ADC-Half Day w/NISP Meal",A2:A40,0),0,COUNTIF(A2:A40,"ADC-Half Day w/NISP Meal"),1)

=OFFSET(B1,MATCH("PERS-Basic Monthly Fee",A2:A40,0),0,COUNTIF(A2:A40,"PERS-Basic Monthly Fee"),1)

=OFFSET(B1,MATCH("PERS-Enhanced Monthly Fee",A2:A40,0),0,COUNTIF(A2:A40,"PERS-Enhanced Monthly Fee"),1)

=OFFSET(B1,MATCH("Representative Payee",A2:A40,0),0,COUNTIF(A2:A40,"Representative Payee"),1)

=OFFSET(B1,MATCH("Representative Payee",A2:A40,0),0,COUNTIF(A2:A40,"Representative Payee"),1)

=OFFSET(B1,MATCH("Guardianship",A2:A40,0),0,COUNTIF(A2:A40,"Guardianship"),1)

Combo.xlsx
	A	B	C	D
1	Service	Provider	Unit Cost
2	Dinner-In-Home Meal	Commission on Economic Opportunity-0002	$5.79
3	Dinner-In-Home Meal	Jewish Community Alliance of Northeastern PA	$8.62
4	Personal Care	Allied in Home Services-0059	$25.00
5	Personal Care	Angels on Call-0023	$21.50
6	Personal Care	Assoicated Family Care-003	$27.50
7	Personal Care	Bayada Home Health-0138	$25.75
8	Personal Care	Caregivers America LLC-0092	$20.60
9	Personal Care	Compass Home Health & Rehab LLC	$26.50
10	Personal Care	Comprehensive Client Care Services-0003	$28.00
11	Personal Care	Erwine's Private Duty Health Care-0006	$43.00
12	Personal Care	Helpmates-0097	$21.72
13	Personal Care	Home Instead Senior Care-0003A	$25.40
14	Personal Care	Home Instead (WB) Senior Care-0004	$27.50
15	Personal Care	Home Sweet Home Personal Care-0002	$28.00
16	Personal Care	Independent Life Home Care and Concierge Solutions-0001	$21.00
17	Personal Care	Interim Health Care Services Inc -0033	$24.95
18	Personal Care	MMS Homecare Staffing-0004	$22.00
19	Personal Care	NEPA Home Care Inc., dba Visiting Angels-0003	$28.00
20	Personal Care	Nurses as Needed-0002	$21.00
21	Personal Care	Platinum Private Duty-0003	$21.75
22	Personal Care	R & L Helpmates-0004	$19.50
23	Personal Care	Revolutionary Nurses-0003	$20.50
24	Personal Care	Telespond Senior Services-0007	$30.00
25	Personal Care	We Care Nurses-0002	$20.00
26	Personal Care/Evenings	Telespond Senior Services-0007	$35.00
27	Personal Care/Weekends	Telespond Senior Services-0007	$35.00
28	ADC-Full Day w/NISP Meal	Keystone ADC Garden Estates-0008	$71.00
29	ADC-Full Day w/NISP Meal	Active Day of Plains-0058	$74.00
30	ADC-Full Day w/NISP Meal	Telespond Senior Services-0007	$72.00
31	ADC-Half Day w/NISP Meal	Active Day of Plains-0058	$57.00
32	ADC-Half Day w/NISP Meal	Telespond Senior Services-0007	$51.00
33	PERS-Basic Monthly Fee	Automated Security Alert-0002	$25.50
34	PERS-Basic Monthly Fee	Caregivers America LLC-0092	$30.00
35	PERS-Basic Monthly Fee	Valued Relationship-0004	$32.00
36	PERS-Enhanced Monthly Fee	Automated Security Alert-0002	$29.50
37	PERS-Enhanced Monthly Fee	Caregivers America-0092	$40.00
38	PERS-Enhanced Monthly Fee	Valued Relationship-0004	$32.00
39	Representative Payee	The Advocacy Alliance-0015	$45.00
40	Guardianship	Family Service Association-0003	$392.00
Providers

 

[Akuini]

I would like to populate the Combo Boxes in Colum D

Do you mean you want to use multiple combobox, one for each row?
How many combobox are you going to use?
I've created a single combobox that can appear and hide automatically when you select a cell in a certain range. So you only need one combobox for multiple cells.
Here's the example:

Best way to create a searchable drop-down list with auto-complete functionality to cells in a column?

Hi Folks, I have a time-sheet workbook with two worksheets (ws). In sheet 1 (the time-sheet ws), Column A is "Employee". Time-sheet worksheet. Employee Start time Finish time Hours worked Joe Blogs Jane Doe I wish to be able to start typing a different employee on each row...

www.mrexcel.com

If you're interested in this method, I think I can modify the code to suit your needs.

 

[jmcease]

Do you mean you want to use multiple combobox, one for each row?
How many combobox are you going to use?
I've created a single combobox that can appear and hide automatically when you select a cell in a certain range. So you only need one combobox for multiple cells.
Here's the example:

Best way to create a searchable drop-down list with auto-complete functionality to cells in a column?

Hi Folks, I have a time-sheet workbook with two worksheets (ws). In sheet 1 (the time-sheet ws), Column A is "Employee". Time-sheet worksheet. Employee Start time Finish time Hours worked Joe Blogs Jane Doe I wish to be able to start typing a different employee on each row...

www.mrexcel.com

If you're interested in this method, I think I can modify the code to suit your needs.

There will be a couple combo boxes as it is based on Service. If you select the first combo box the selections would be tied to the providers for Dinner-In-Home Meal, the next combo box would be personal care and so on.

 

[Akuini]

I don't quite understand your explanation.
So there are 2 combobox, are they dependent combobox? so when you pick an item in combobox1 then it will change the list in combobox2?
Can you explain in more detail?

 

[jmcease]

I don't quite understand your explanation.
So there are 2 combobox, are they dependent combobox? so when you pick an item in combobox1 then it will change the list in combobox2?
Can you explain in more detail?

The combo boxes are located on a sheet where a user will be selecting a vendor who provides Services(Provider). So there will be 10 combo boxes next to a Service - first one Dinner-In-Home Meals and the combo box would be a selection of 2 as there are two providers for that service. Next there will be a combo fox next to Personal Care of which there will be a selection 22 as there are 22 providers for that service. This will continue the Service is not a dropdown or combo box. It is just a section on a sheet

 

[Akuini]

Could you upload a sample workbook along with all the combobox (without sensitive data) to a sharing site like dropbox.com or google drive?
And then share the link here.
This will make it easier to understand & find a solution.