Realizar filtro de acuerdo a número de fila

[dragonfire33]

Como puedo realizar un filtro de acuerdo al número de la fila como está en la parte derecha y que este me arroje un número de 4 cifras de acuerdo a las combinaciones del filtro

 

[RobP]

sorry, I rely on Google for Spanish Maybe like this :

Book1
	BA	BB	BC	BD	BE	BF
1		1	0	8	9
2
3
4
5		1	0
6
7			0	8
8
9				8	9
10
11		1			9
12
13		1		8
14
15			0		9
16
17
18
Sheet1

Cell Formulas
Range	Formula
BB1:BE1	BB1	=MAX(BB5:BB16)

Sorry, I realise maybe I got the question backwards ? You want to enter the 4 digit code manually and pull the data ?

 

[RobP]

So I try something like this:

=LET(a,IF(ISBLANK(FILTER(A2:H1000,A2:A1000&B2:B1000=BB1&BC1)),"",FILTER(A2:H1000,A2:A1000&B2:B1000=BB1&BC1)),a)

 

[dragonfire33]

Your answer does not match the filter I want taking into account the entirety of the cells of the rest of the sheet

 

[RobP]

yes, you are correct, sorry, I cannot find a way to pull the second row of data each time.

I see you are able to code using VBA - maybe this is a solution for you ?

Sorry I couldn't find a formula.

Rob