Help needed please.

[stevenwiezorek]

The list on the left are items that I want to assign a group number to and the list to the right is the group descriptions with their corresponding group number. How do I write a formula in which whenever I type one of the 8 group descriptions in Column B, its corresponding number automatically inputted into column A. I'm sorry if this isn't very clear. If you need me to clear anything up, please ask.

 

[gordsky]

View attachment 60138View attachment 60139

The list on the left are items that I want to assign a group number to and the list to the right is the group descriptions with their corresponding group number. How do I write a formula in which whenever I type one of the 8 group descriptions in Column B, its corresponding number automatically inputted into column A. I'm sorry if this isn't very clear. If you need me to clear anything up, please ask.

maybe something like this into A2 and then copied down column A

=MATCH($B2,YOURRANGE,0)

Change the YOURRANGE to be the range where your text in white is located

 

[jtakw]

Hi,

One way with formula:

Book3.xlsx
	A	B	C	D	E
1				0	a
2	2	c		1	b
3	5	f		2	c
4	4	e		3	d
5	8	i		4	e
6	0	a		5	f
7				6	g
8				7	h
9				8	i
Sheet1047

Cell Formulas
Range	Formula
A2:A6	A2	=LOOKUP(2,1/(E$1:E$9=B2),D$1:D$9)

 

[Fluff]

@gordsky you would need to subtract 1 from your formula as the numbers start at 0.

 

[stevenwiezorek]

maybe something like this into A2 and then copied down column A

=MATCH($B2,YOURRANGE,0)

Change the YOURRANGE to be the range where your text in white is located

@gordsky you would need to subtract 1 from your formula as the numbers start at 0.

I am now at this problem, how do I subtract 1 so I can get the table to output correctly?

 

[Fluff]

Just put a -1 at the very end of the formula.

 

[stevenwiezorek]

Thank you everyone!

 

[Fluff]

Glad we could help & thanks for the feedback.