"Vlookup unrepeated values"

[Marwan69]

Hello everyone,

I have a list of items and some of these items are repeated in every other 10 or so rows: For example:

size_sku​	product​	size​	ingredient_sku​	ingredient_name​
43​	Cappuccino​	Small​	sku_111​	Coffee Double/Single Shot​
43​	Cappuccino​	Small​	sku_115​	Kraft Ripple Paper Cup 8oz​
43​	Cappuccino​	Small​	sku_116​	Kraft Ripple Paper Cup 12oz​
43​	Cappuccino​	Small​	sku_117​	Black Plastic Lid 8oz​
43​	Cappuccino​	Small​	sku_118​	Black Plastic Lid 12oz​
43​	Cappuccino​	Small​	sku_124​	Brown Paper Napkin​
43​	Cappuccino​	Small​	sku_126​	2-Cup tray​
43​	Cappuccino​	Small​	sku_129​	Brown Wrapped Wooden Stirrer​
43​	Cappuccino​	Small​	sku_156​	Full Fat Milk Nadic​
43​	Cappuccino​	Small​	sku_172​	Sugar Satchet​
43​	Cappuccino​	Small​	sku_201​	Cocoa Alalali​
			Total​
44​	Cappuccino​	Medium​	sku_111​	Coffee Double/Single Shot​
44​	Cappuccino​	Medium​	sku_115​	Kraft Ripple Paper Cup 8oz​
44​	Cappuccino​	Medium​	sku_116​	Kraft Ripple Paper Cup 12oz​
44​	Cappuccino​	Medium​	sku_117​	Black Plastic Lid 8oz​
44​	Cappuccino​	Medium​	sku_118​	Black Plastic Lid 12oz​
44​	Cappuccino​	Medium​	sku_124​	Brown Paper Napkin​
44​	Cappuccino​	Medium​	sku_126​	2-Cup tray​
44​	Cappuccino​	Medium​	sku_129​	Brown Wrapped Wooden Stirrer​
44​	Cappuccino​	Medium​	sku_156​	Full Fat Milk Nadic​
44​	Cappuccino​	Medium​	sku_172​	Sugar Satchet​
44​	Cappuccino​	Medium​	sku_201​	Cocoa Alalali​
			Total​
45​	Macchiato​	Small​	sku_111​	Coffee Double/Single Shot​
45​	Macchiato​	Small​	sku_115​	Kraft Ripple Paper Cup 8oz​
45​	Macchiato​	Small​	sku_116​	Kraft Ripple Paper Cup 12oz​
45​	Macchiato​	Small​	sku_117​	Black Plastic Lid 8oz​
45​	Macchiato​	Small​	sku_118​	Black Plastic Lid 12oz​
45​	Macchiato​	Small​	sku_124​	Brown Paper Napkin​
45​	Macchiato​	Small​	sku_126​	2-Cup tray​
45​	Macchiato​	Small​	sku_129​	Brown Wrapped Wooden Stirrer​
45​	Macchiato​	Small​	sku_156​	Full Fat Milk Nadic​
45​	Macchiato​	Small​	sku_172​	Sugar Satchet​
			Total​
46​	Macchiato​	Medium​	sku_111​	Coffee Double/Single Shot​
46​	Macchiato​	Medium​	sku_115​	Kraft Ripple Paper Cup 8oz​
46​	Macchiato​	Medium​	sku_116​	Kraft Ripple Paper Cup 12oz​
46​	Macchiato​	Medium​	sku_117​	Black Plastic Lid 8oz​
46​	Macchiato​	Medium​	sku_118​	Black Plastic Lid 12oz​
46​	Macchiato​	Medium​	sku_124​	Brown Paper Napkin​
46​	Macchiato​	Medium​	sku_126​	2-Cup tray​
46​	Macchiato​	Medium​	sku_129​	Brown Wrapped Wooden Stirrer​
46​	Macchiato​	Medium​	sku_156​	Full Fat Milk Nadic​
46​	Macchiato​	Medium​	sku_172​	Sugar Satchet​
			Total​
47​	Espresso/Double​	Small​	sku_110​	Brown Kraft Paper 4oz​
47​	Espresso/Double​	Small​	sku_111​	Coffee Double/Single Shot​
47​	Espresso/Double​	Small​	sku_124​	Brown Paper Napkin​
			Total​

So, I want "Vlookup" function to pick up only one of ie: "Coffee Double/Single Shot" and not all the "Coffee Double/Single Shot". It doesn't matter which one to pick but most importantly
one of this item only "Coffee Double/Single Shot". How to do that?

Many thanks,
Marwan

 

[Joe4]

VLOOKUP will only pick up the first one it finds. So, that sounds like it might already meet your requirements.
If not, then I am not clear on what you are looking for, so please explain in more detail and show us what your expected output is.

 

[Marwan69]

Thanks Joe4. But it returns error. Am expecting a return of specific item whether with vlookup or some other function sir.

 

[Joe4]

Thanks Joe4. But it returns error

Then there is probably an error in the way you wrote it.
Can you post your formula?
Also, what is it exactly that you want returned? Do you want one of the other columns (like sku number) returned?

 

[Marwan69]

I actually want the cost of the item. I appologize I didn’t put the cost. But any how i was thinking if i could get that item alone the rest will follow suit.

 

[Joe4]

Whether you can use VLOOKUP or have to use something else (like INDEX/MATCH) depends very much on the structure of your data.
Most importantly, we need to know which column the ingredient_name is in, and which column your cost is in.
If the cost column is to the left of the ingredient_name column, you cannot use VLOOKUP.

 

[Marwan69]

Write. I’ll post them here.
Thanks ?

 

[Marwan69]

Products Recipe-Final.xlsx
	A	B	C	D	E	F	G	H
6	size_sku	product	size	ingredient_sku	ingredient_name	ingredient_quantity	ingredient_unit	ingredient_total_cost
7	43	Cappuccino	Small	sku_111	Coffee Double/Single Shot	18	g	1.346
8	43	Cappuccino	Small	sku_115	Kraft Ripple Paper Cup 8oz	1	Pcs	0.265
9	43	Cappuccino	Small	sku_116	Kraft Ripple Paper Cup 12oz	0	Pcs	0
10	43	Cappuccino	Small	sku_117	Black Plastic Lid 8oz	1	Pcs	0.081
11	43	Cappuccino	Small	sku_118	Black Plastic Lid 12oz	0	Pcs	0
12	43	Cappuccino	Small	sku_124	Brown Paper Napkin	2	Pcs	0.069
13	43	Cappuccino	Small	sku_126	2-Cup tray	1	Pcs	0.216
14	43	Cappuccino	Small	sku_129	Brown Wrapped Wooden Stirrer	1	Pcs	0.03
15	43	Cappuccino	Small	sku_156	Full Fat Milk Nadic	250	ml	0.838
16	43	Cappuccino	Small	sku_172	Sugar Satchet	2	Pcs	0.052
17	43	Cappuccino	Small	sku_201	Cocoa Alalali	1	mg	0
18								2.896
19	44	Cappuccino	Medium	sku_111	Coffee Double/Single Shot	36	g	2.693
20	44	Cappuccino	Medium	sku_115	Kraft Ripple Paper Cup 8oz	0	Pcs	0
21	44	Cappuccino	Medium	sku_116	Kraft Ripple Paper Cup 12oz	1	Pcs	0.322
22	44	Cappuccino	Medium	sku_117	Black Plastic Lid 8oz	0	Pcs	0
23	44	Cappuccino	Medium	sku_118	Black Plastic Lid 12oz	1	Pcs	0.086
24	44	Cappuccino	Medium	sku_124	Brown Paper Napkin	2	Pcs	0.069
25	44	Cappuccino	Medium	sku_126	2-Cup tray	1	Pcs	0.216
26	44	Cappuccino	Medium	sku_129	Brown Wrapped Wooden Stirrer	1	Pcs	0.03
27	44	Cappuccino	Medium	sku_156	Full Fat Milk Nadic	360	ml	1.206
28	44	Cappuccino	Medium	sku_172	Sugar Satchet	2	Pcs	0.052
29	44	Cappuccino	Medium	sku_201	Cocoa Alalali	1	mg	0
30								4.674
31	45	Macchiato	Small	sku_111	Coffee Double/Single Shot	18	g	1.346
32	45	Macchiato	Small	sku_115	Kraft Ripple Paper Cup 8oz	1	Pcs	0.265
33	45	Macchiato	Small	sku_116	Kraft Ripple Paper Cup 12oz	0	Pcs	0
34	45	Macchiato	Small	sku_117	Black Plastic Lid 8oz	1	Pcs	0.081
35	45	Macchiato	Small	sku_118	Black Plastic Lid 12oz	0	Pcs	0
36	45	Macchiato	Small	sku_124	Brown Paper Napkin	2	Pcs	0.069
37	45	Macchiato	Small	sku_126	2-Cup tray	1	Pcs	0.216
38	45	Macchiato	Small	sku_129	Brown Wrapped Wooden Stirrer	1	Pcs	0.03
39	45	Macchiato	Small	sku_156	Full Fat Milk Nadic	60	ml	0.201
40	45	Macchiato	Small	sku_172	Sugar Satchet	2	Pcs	0.052
41								2.26
42	46	Macchiato	Medium	sku_111	Coffee Double/Single Shot	36	g	2.693
43	46	Macchiato	Medium	sku_115	Kraft Ripple Paper Cup 8oz	0	Pcs	0
44	46	Macchiato	Medium	sku_116	Kraft Ripple Paper Cup 12oz	1	Pcs	0.322
45	46	Macchiato	Medium	sku_117	Black Plastic Lid 8oz	0	Pcs	0
46	46	Macchiato	Medium	sku_118	Black Plastic Lid 12oz	1	Pcs	0.086
47	46	Macchiato	Medium	sku_124	Brown Paper Napkin	2	Pcs	0.069
48	46	Macchiato	Medium	sku_126	2-Cup tray	1	Pcs	0.216
49	46	Macchiato	Medium	sku_129	Brown Wrapped Wooden Stirrer	1	Pcs	0.03
50	46	Macchiato	Medium	sku_156	Full Fat Milk Nadic	60	ml	0.201
51	46	Macchiato	Medium	sku_172	Sugar Satchet	2	Pcs	0.052
52								3.669
53	47	Espresso/Double	Small	sku_110	Brown Kraft Paper 4oz	1	Pcs	0.083
54	47	Espresso/Double	Small	sku_111	Coffee Double/Single Shot	18	g	1.346
55	47	Espresso/Double	Small	sku_124	Brown Paper Napkin	2	Pcs	0.069
56								1.498
57	48	Espresso/Double	Medium	sku_110	Brown Kraft Paper 4oz	1	Pcs	0.083
58	48	Espresso/Double	Medium	sku_111	Coffee Double/Single Shot	36	g	2.693
59	48	Espresso/Double	Medium	sku_124	Brown Paper Napkin	2	Pcs	0.069
60								2.845
Products Recipes

 

[Joe4]

OK, so it looks like its column E and H.

So it could be something like:
=VLOOKUP("Coffee Double/Single Shot",E7:H59,4,0)

If the value you want to look up is in a certain cell, just replace "Coffee Double/Single Shot" with that cell address.

 

[Marwan69]

I’ll try but the value is in another sheet. Ie: Coffee Double/Single Shot.
Many thanks ?