Formula to for extracting update list with criteria

[GerryZ]

hello Excel guru
I will never make this without your help
I've two tables the Above table is the wrong result and in the table belowe is the expected outcome

As you can see in colum A of both tables I've all the code of all Employes but code 35,66,92 for some reason they don't work any more

in column B of both tables I' ve the UPDATED list of the Employd but i need to list them like in the table belowe so I can keep track of old code that I can use for new Emploies
Ihope is clear
Thank you!

Book1
	A	B	C	D	E
1	WRONG	TABLE
2	OLD LIST	UPDATED	LAST NAME	FIRST NAME	BORN
3	11	11	ROSSI	ALDO	1/1/1965
4	23	23	VERDI	MARIO	1/1/1966
5	35	44	BIANCHI	LUIGI	3/2/1970
6	44	56	ROSSI	MARIO	3/3/1969
7	56	78	VERDI	GIANNI	5/4/1956
8	66	89	BIANCHI	LUCA	13/5/1978
9	78	101	BLU	ALDA	15/4/1988
10	89
11	92
12	101
13
14	CORRECT	TABLE
15	OLD LIST	UPDATE	LAST NAME	FIRST NAME	BORN
16	11	11	ROSSI	ALDO	1/1/1965
17	23	23	VERDI	MARIO	1/1/1966
18	35
19	44	44	BIANCHI	LUIGI	3/2/1970
20	56	56	ROSSI	MARIO	3/3/1969
21	66
22	78	78	VERDI	GIANNI	5/4/1956
23	89	89	BIANCHI	LUCA	13/5/1978
24	92
25	101	101	BLU	ALDA	15/4/1988
Foglio1 (2)

 

[gaz_chops]

Hi Gerry, what formula are you using to get the information into C, D & E?

 

[GerryZ]

Hi Gaz nice to see you
I'm not using any formula, this is vergin spreedsheet
anyway I forgot to mantion that this list as 3000 rows thats why i need one formula.
I was thinking to make a criteria list 35, 66, 92
Thank you Gaz

 

[AkaTrouble]

if i am understanding requirement

working on creating new table

in row A copied down using CSE (control shift enter_

=INDEX(A1:E10,1,1)

in column B dragged down and across to column E no need for CSE

=IFERROR(VLOOKUP($A13,$B$1:$E$10,COLUMN()-1,FALSE),"")

 

[J.Ty.]

Hi Gerry,


Is this what you need?

J.Ty.

Excel 2010
	A	B	C	D	E
1	WRONG	TABLE
2	OLD LIST	UPDATED	LAST NAME	FIRST NAME	BORN
3	11	11	ROSSI	ALDO	1/1/1965
4	23	23	VERDI	MARIO	1/1/1966
5	35	44	BIANCHI	LUIGI	3/2/1970
6	44	56	ROSSI	MARIO	3/3/1969
7	56	78	VERDI	GIANNI	5/4/1956
8	66	89	BIANCHI	LUCA	13/5/1978
9	78	101	BLU	ALDA	15/4/1988
10	89
11	92
12	101
13
14	CORRECT	TABLE
15	OLD LIST	UPDATE	LAST NAME	FIRST NAME	BORN
16	11	11	ROSSI	ALDO	1/1/1965
17	23	23	VERDI	MARIO	1/1/1966
18	35
19	44	44	BIANCHI	LUIGI	3/2/1970
20	56	56	ROSSI	MARIO	3/3/1969
21	66
22	78	78	VERDI	GIANNI	5/4/1956
23	89	89	BIANCHI	LUCA	13/5/1978
24	92
25	101	101	BLU	ALDA	15/4/1988
Sheet1

Cell Formulas
Range	Formula
B16	=IFERROR(INDEX(B$3:B$9,MATCH($A16,$B$3:$B$9,0)),"")
C16	=IFERROR(INDEX(C$3:C$9,MATCH($A16,$B$3:$B$9,0)),"")
D16	=IFERROR(INDEX(D$3:D$9,MATCH($A16,$B$3:$B$9,0)),"")
E16	=IFERROR(INDEX(E$3:E$9,MATCH($A16,$B$3:$B$9,0)),"")

 

[GerryZ]

Hi Gerry,


Is this what you need?

J.Ty.

Excel 2010
	A	B	C	D	E
1	WRONG	TABLE
2	OLD LIST	UPDATED	LAST NAME	FIRST NAME	BORN
3	11	11	ROSSI	ALDO	1/1/1965
4	23	23	VERDI	MARIO	1/1/1966
5	35	44	BIANCHI	LUIGI	3/2/1970
6	44	56	ROSSI	MARIO	3/3/1969
7	56	78	VERDI	GIANNI	5/4/1956
8	66	89	BIANCHI	LUCA	13/5/1978
9	78	101	BLU	ALDA	15/4/1988
10	89
11	92
12	101
13
14	CORRECT	TABLE
15	OLD LIST	UPDATE	LAST NAME	FIRST NAME	BORN
16	11	11	ROSSI	ALDO	1/1/1965
17	23	23	VERDI	MARIO	1/1/1966
18	35
19	44	44	BIANCHI	LUIGI	3/2/1970
20	56	56	ROSSI	MARIO	3/3/1969
21	66
22	78	78	VERDI	GIANNI	5/4/1956
23	89	89	BIANCHI	LUCA	13/5/1978
24	92
25	101	101	BLU	ALDA	15/4/1988
Sheet1

Cell Formulas
Range	Formula
B16	=IFERROR(INDEX(B$3:B$9,MATCH($A16,$B$3:$B$9,0)),"")
C16	=IFERROR(INDEX(C$3:C$9,MATCH($A16,$B$3:$B$9,0)),"")
D16	=IFERROR(INDEX(D$3:D$9,MATCH($A16,$B$3:$B$9,0)),"")
E16	=IFERROR(INDEX(E$3:E$9,MATCH($A16,$B$3:$B$9,0)),"")

hello EveryBoby!!
I will use J.Ty.'s formula that works perfectly
Woooooww! Is so simple
I should know the answer, I had the head locked
Thanks everybody for the answers