Group number return.

[serge]

Hi everyone,

I have 3 different groups that each one contain numbers.

Group 1 = 5,8,10.
Group 2 = 2,3,6,9.
Group 3 = 1,4,7.

Then in column D there is numbers that are either from group 1,2 or 3.
I'm looking for a formula that will return the group number either 1,2 or3 in G6:I6.

Thank you.

Excel Workbook
	C	D	E	F	G	H	I	J
1					Group
2					1	2	3
3
4
5
6		8			1
7		2				2
8		7					3
9		1					3
10		5			1
11		4					3
12		3				2
13
Sheet

 

[Danerida]

Cell G6 =IF(OR($D6={5,8,10}),1,"")
Cell H6 =IF(OR($D6={2,3,6,9}),2,"")
Cell I6=IF(OR($D6={1,4,7}),3,"")
If you want the group number returned in the one column use this =IF(OR($D6={5,8,10}),1,IF(OR($D6={2,3,6,9}),2,IF(OR($D6={1,4,7}),3,"")))

All formulas should be copied down as needed.

Dan

 

[serge]

Hi Danerida,

Thank you very much for the formulas that's exactly what I needed.

Really appreciate the help.

Serge.

 

[Danerida]

You're most welcome.