Returning one single numer.

[serge]

Hello everyone,
I have those 9 numbers in that example in row 7 and I have 4 separate position columns A:D and 3 separate row 3:5.
If I type digit 2 in A:3 which is the 1st position I need a formula starting in F:3 and dragging right to return all numbers that start with a 2.

Same thing if I would type a different digit in the 3rd position it would return all the numbers that have that digit in their 3rd position.

Then in row 4, I have a 0 as a 3rd position so it would return all numbers that have 2 in 1st position and 0 in 3rd position with here reduce to 3 numbers.

Then the final digit here the 2 in the 4th position will return a single number.
I hope it's clear enough to understand ?
Thank you.

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Pos 1	Pos 2	Pos 3	Pos 4
2
3
4			0			2103	2202	2301	3102	3201	4101
5	2		0			2103	2202	2301
6
7	2103	2121	2202	2211	2301	3102	3111	3201	4101
Sheet3

Cell Formulas
Range	Formula
F3:K5	F3	=IF(COUNTA($A3:$D3)=0,"",IF(ISERROR(SMALL(IF(MMULT((MID(TRANSPOSE($A$7:$I$7),IF($A3:$D3="",9,{1,2,3,4}),1)=$A3:$D3&"")+0,{1;1;1;1})=4,TRANSPOSE($A$7:$I$7),""),COLUMNS($F:F))),"",SMALL(IF(MMULT((MID(TRANSPOSE($A$7:$I$7),IF($A3:$D3="",9,{1,2,3,4}),1)=$A3:$D3&"")+0,{1;1;1;1})=4,TRANSPOSE($A$7:$I$7),""),COLUMNS($F:F))))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[serge]

PERFECT you did it, I wont other you no more Thank you so much.

 

[Eric W]

Glad we could help.