Need help bringing a partial match from a separate sheet into a partial starting primary source

[thejoenius]

Hi guys, long time reader first time poster. Got a bit of a weird one i can't figure out.

Here's whats going on:

I have a sheet that has some Signs we're going to print. I need to verify that the price in column E matches what is in the export from our database on a different sheet. The problem arises in that i have to match the export up with a partial name of the Brand in column C against the brand on the export sheet -- but it's not exact, or complete. Some brands have the same amount, some have 15 more listed. This is because there are several "signs" that are group signs for one category of products (highlighted in green). Those items will just get one sign for the entire group (price is all the same).

I'm hoping to be able to pull all of the brands from the Export sheet and do a partial match against the names of items on the Sign sheet so i can return the Product Number and just match everything up from there. However, I feel like i'll need to go in and manually create a bunch of new lines for each and every brand anyways which is so granular i might as well just do it all by hand. I'm wondering if it can be done with some sort of filter formula, but im not sure how you would tie it out against the NAME of the product.

Honestly, I'm just kind of lost here. It seems like there is just too many partial matches for anything to be cleanly matched up without doing it all manually. Any and all help is appreciated. Full data set is around 3k lines on both sheets, +/- about 1k items.

Thanks guys!

SIGNS SHEET

signage.xlsx
	A	B	C	D	E	F	G
1	LOC	CARD SIZE	BRAND	NAME	SIGN PRICE	COMMENTS 1	PRODUCT NUMBER
2	P	Card 20	776	Greek Honeys	$16.00
3	A	Card 20	Magna Olea	Gourmet PDO Olive Oil	$35.00
4		Card 20	4th & Heart	Himalayan Pink Salt Ghee	$21.00
5	A	Card 20	776 Deluxe Foods	Olympia Extra Virgin Olive Oil	$18.00
6	B	Card 20	A L'Olivier	Fruit Vinegars	$16.00
7	B	Card 20	A L'Olivier	Bordeaux Vinegar	$8.00
8	B	Card 20	A L'Olivier	Tomato Basil Vinegar	$13.00
9	E	Card 20	A L'Olivier	French Vinaigrettes	$17.00
10	A	Card 20	Aceitunas Losada Olives	Carmona Olives	$9.00
11	P	Card 20	Activist	100+ Manuka	$40.00
12	P	Card 20	Activist	300+ Manuka	$55.00
13	P	Card 20	Activist	50+ Manuka	$30.00
14	P	Card 20	Activist	850+ Manuka	$105.00
15	P	Card 20	Activist	1000+ Manuka	$200.00
16	P	Card 20	Activist	100+ Manuka	$40.00
17	P	Card 20	Activist	300+ Manuka	$55.00
18	P	Card 20	Activist	50+ Manuka	$30.00
19	P	Card 20	Activist	850+ Manuka	$105.00
Signs

EXPORT SHEET

signage.xlsx
	A	B	C	D
1	Product Number	Brand Name	Item Name	Selling Price
2	R101069	4th Heart Ghee	Himalayan Salt 9oz	21
3	R101068	4th Heart Ghee	Original 9oz	21
4	R107046	776 Deluxe Foods Honey	Mastica 8.8oz	16
5	R107047	776 Deluxe Foods Honey	Thyme 8.8oz	16
6	R100018	776 Deluxe Foods Olive Oil	EVOO	19
7	R111000	88 Acres Butter	Organic Pumpkin Seed 14oz	17
8	R111001	88 Acres Butter	Sunflower Dark Chocolate 14oz	15
9	R100028	A L'Olivier Olive Oil	Basil Tin 250ml	14.5
10	R100033	A L'Olivier Olive Oil	Crock 500ml	36
11	R100030	A L'Olivier Olive Oil	Garlic & Thyme Tin 250ml	14.5
12	R100260	A L'Olivier Olive Oil	Herbes de Provence bottle 8.3oz	20
13	R100029	A L'Olivier Olive Oil	Herbes de Provence Tin 250ml	14.5
14	R100031	A L'Olivier Olive Oil	Lavender Tin 150ml	9.5
15	R100032	A L'Olivier Olive Oil	Lemon & Thyme Tin 150ml	9.5
16	R100027	A L'Olivier Olive Oil	Porcini Truffle Tin 250ml	16.5
17	R100034	A L'Olivier Olive Oil	White Drum 700ml	35
18	R106002	A l'Olivier Vinaigrette	Coconut & Lime 6.76oz	17
19	R106001	A l'Olivier Vinaigrette	Mango & Lemongrass 6.76oz	17
20	R106000	A l'Olivier Vinaigrette	Pineapple & Basil 6.76oz	17
21	R100023	A L'Olivier Vinegar	Basque Pepper 250ml	13
22	R100022	A L'Olivier Vinegar	Fig 200ml	16
23	R100021	A L'Olivier Vinegar	Mango 200ml	16
24	R100020	A L'Olivier Vinegar	Passionfruit 200ml	16
25	R100019	A L'Olivier Vinegar	Raspberry 200ml	16
26	R100025	A L'Olivier Vinegar	Red Wine Bordeaux 250ml	8
27	R100024	A L'Olivier Vinegar	Tomato Basil 250ml	13
28	R100026	A L'Olivier Vinegar	White Wine 250ml	8
29	R100229	A L'Olvier Olive Oil	Espelette Pepper 8.3oz	20
30	R100230	A L'Olvier Olive Oil	Lemon 8.3oz	20
31	R113094	Aberth Menes	Poppy Seed Biscuits	7
32	R113095	Aberth Menes	Swiss Biscuits	7
33	R107169	Actvist	Manuka 100 12oz	40
34	R107108	Actvist	Manuka 1000 12oz	200
35	R107096	Actvist	Manuka 300 12oz	55
36	R107107	Actvist	Manuka 50 12oz	30
37	R107170	Actvist	Manuka 850 12oz	105
38	R107087	Actvist	Manuka Elixir 30ml	42
EXPORT