Return value from list if found in column

[Apples52]

Hi, I tried searching for this already but couldn't find an asnwer to get me the result I need.

In column "K" I want a result returned from the list in column J if a number from column I appears in column B.

For example, if the number 2 appears in column B, return "Apples"- so K2, K10 and K18 should be "Apples". If the number 3 appears in column B, return "Pears"- so K3, K11 and K19 should be "Pears" and so on.

Thank you in advance.

 

[Asbestos_Jen]

Try this:

2024-06-25.xlsx
	A	B	C	D					I	J	K
1	site_no	dept_no	month1_sales	month1_cogs					#	List	Dept. Descr
2		2							2	Apples	Apples
3		3							3	Pears	Pears
4		4							4	Oranges	Oranges
5		5							5	Mangos	Mangos
6		6							6	Kiwi	Kiwi
7		7							7	Strawberries	Strawberries
8		8							8	Raspberries	Raspberries
9		9							9	Blueberries	Blueberries
10		2									Apples
11		3									Pears
12		4									Oranges
13		5									Mangos
14		6									Kiwi
15		7									Strawberries
16		8									Raspberries
17		9									Blueberries
18		2									Apples
19		3									Pears
Sheet3

Cell Formulas
Range	Formula
K2:K19	K2	=VLOOKUP(B2,$I$2:$J$9,2)

 

[Apples52]

Try this:

2024-06-25.xlsx
	A	B	C	D					I	J	K
1	site_no	dept_no	month1_sales	month1_cogs					#	List	Dept. Descr
2		2							2	Apples	Apples
3		3							3	Pears	Pears
4		4							4	Oranges	Oranges
5		5							5	Mangos	Mangos
6		6							6	Kiwi	Kiwi
7		7							7	Strawberries	Strawberries
8		8							8	Raspberries	Raspberries
9		9							9	Blueberries	Blueberries
10		2									Apples
11		3									Pears
12		4									Oranges
13		5									Mangos
14		6									Kiwi
15		7									Strawberries
16		8									Raspberries
17		9									Blueberries
18		2									Apples
19		3									Pears
Sheet3

Cell Formulas
Range	Formula
K2:K19	K2	=VLOOKUP(B2,$I$2:$J$9,2)

YES, Thank You!

 

[Asbestos_Jen]

Happy to help