IFERROR, but not use previously used?

[cspengel]

Not exactly sure How to describe my exact issue. I have two tables as such below.

showdown4.xlsm
	A	B	C	D	E	F	G	H	I	J
1	MVP	FLEX	FLEX2	FLEX3	FLEX4	CAR	FLEX	FLEX2	FLEX3	FLEX4
2	RB1	QB1	D			ATL	TE1	QB1
3	QB1	TE2	WR3	WR1			RB1
4	WR1						WR4	QB1	TE1	K
5	RB1	TE1	QB1				D	QB1
6	WR1	TE1	QB1				WR2	WR3
7	QB1						WR1	K	RB2	RB1
8	RB1	WR2	QB1	WR1			WR1
9	WR1	QB1					TE2	D	QB1
10	WR1						WR3	K	WR1	RB1
11	QB1	TE1	WR1				RB2	QB1
12	RB1	QB1					RB3	QB1	WR4
13	D	RB1	QB1	K			D
14	QB1	TE1	RB1	RB2			WR1
15	RB1	D	WR1	QB1			D
16	WR1						WR5	WR1	QB1	RB1
17	QB1	RB3	WR1				K	RB2
18	QB1	WR2	D				TE2	RB1
19	RB1	TE1	WR1	QB1			RB3
20	RB1	RB2	D				RB1	D
21	WR1	D	WR4	QB1			WR2
22	QB1	RB3	WR2	WR1			K
23	WR1	WR2	QB1				RB1	WR3
24	RB1	D	QB1	TE2			WR2
25	TE1	QB1					K	WR2	RB2
26	RB1	WR1					K	QB1	WR5
27	RB1	QB1					WR5	RB2	QB1
28	RB1	TE1					WR2	RB2	QB1
29	QB1	WR2	TE2	RB2			QB1
30	QB1	RB2	K				WR2	RB2
31	RB1	D	QB1				QB1	WR3
32	RB1	QB1					WR3	RB1	K
33	QB1	WR3	WR1				WR4	TE1
34	RB1	WR2					QB1	WR4	RB1
35	RB1	K					QB1	WR2	RB1
36	RB3	QB1	D	K			RB1
37	D	RB2	QB1	RB1			WR3
38	D	RB1	K				WR2	RB1
39	QB1	WR1	WR3				WR5	RB1
Lines

I have another table to the right of those tables like so:

showdown4.xlsm
	L	M	N	O	P
1	MVP	FLEX	FLEX2	FLEX3	FLEX4
2	D'Onta Foreman	P.J. Walker	P.J. Walker	Kyle Pitts	Kyle Pitts
3	P.J. Walker	Ian Thomas		DJ Moore	DJ Moore
4	DJ Moore	Damiere Byrd	Damiere Byrd	Kyle Pitts	Kyle Pitts
5	D'Onta Foreman	Tommy Tremble	Tommy Tremble	Atlanta Falcons	Atlanta Falcons
6	DJ Moore	Tommy Tremble	Tommy Tremble	Olamide Zaccheaus	Olamide Zaccheaus
7	P.J. Walker	Drake London	Drake London	Tyler Allgeier	Tyler Allgeier
8	D'Onta Foreman	Laviska Shenault Jr.	Laviska Shenault Jr.	DJ Moore	DJ Moore
9	DJ Moore	P.J. Walker	P.J. Walker	Marcus Mariota	Marcus Mariota
10	DJ Moore	KhaDarel Hodge	KhaDarel Hodge	Drake London	Drake London
11	P.J. Walker	Tommy Tremble	Tommy Tremble	Tyler Allgeier	Tyler Allgeier
12	D'Onta Foreman	P.J. Walker	P.J. Walker	Damiere Byrd	Damiere Byrd
13	Carolina Panthers	D'Onta Foreman	D'Onta Foreman	Eddy Pineiro	Eddy Pineiro
14	P.J. Walker	Tommy Tremble	Tommy Tremble	Chuba Hubbard	Chuba Hubbard
15	D'Onta Foreman	Carolina Panthers	Carolina Panthers	P.J. Walker	P.J. Walker
16	DJ Moore	#N/A	#N/A	Marcus Mariota	Marcus Mariota
17	P.J. Walker	Raheem Blackshear	Raheem Blackshear	Younghoe Koo	Younghoe Koo
18	P.J. Walker	Laviska Shenault Jr.	Laviska Shenault Jr.	Parker Hesse	Parker Hesse
19	D'Onta Foreman	Tommy Tremble	Tommy Tremble	P.J. Walker	P.J. Walker
20	D'Onta Foreman	Chuba Hubbard	Chuba Hubbard	Cordarrelle Patterson	Cordarrelle Patterson
21	DJ Moore	Carolina Panthers	Carolina Panthers	P.J. Walker	P.J. Walker
22	P.J. Walker	Raheem Blackshear	Raheem Blackshear	DJ Moore	DJ Moore
23	DJ Moore	Laviska Shenault Jr.	Laviska Shenault Jr.	Cordarrelle Patterson	Cordarrelle Patterson
24	D'Onta Foreman	Carolina Panthers	Carolina Panthers	Ian Thomas	Ian Thomas
25	Tommy Tremble	P.J. Walker	P.J. Walker	Tyler Allgeier	Tyler Allgeier
26	D'Onta Foreman	DJ Moore	DJ Moore	Younghoe Koo	Younghoe Koo
27	D'Onta Foreman	P.J. Walker	P.J. Walker	Marcus Mariota	Marcus Mariota
28	D'Onta Foreman	Tommy Tremble	Tommy Tremble	Marcus Mariota	Marcus Mariota
29	P.J. Walker	Laviska Shenault Jr.	Laviska Shenault Jr.	Chuba Hubbard	Chuba Hubbard
30	P.J. Walker	Chuba Hubbard	Chuba Hubbard	Olamide Zaccheaus	Olamide Zaccheaus
31	D'Onta Foreman	Carolina Panthers	Carolina Panthers	Marcus Mariota	Marcus Mariota
32	D'Onta Foreman	P.J. Walker	P.J. Walker	Younghoe Koo	Younghoe Koo
33	P.J. Walker	Shi Smith	Shi Smith	Damiere Byrd	Damiere Byrd
34	D'Onta Foreman	Laviska Shenault Jr.	Laviska Shenault Jr.	Cordarrelle Patterson	Cordarrelle Patterson
35	D'Onta Foreman	Eddy Pineiro	Eddy Pineiro	Cordarrelle Patterson	Cordarrelle Patterson
36	Raheem Blackshear	P.J. Walker	P.J. Walker	Eddy Pineiro	Eddy Pineiro
37	Carolina Panthers	Chuba Hubbard	Chuba Hubbard	D'Onta Foreman	D'Onta Foreman
38	Carolina Panthers	D'Onta Foreman	D'Onta Foreman	Olamide Zaccheaus	Olamide Zaccheaus
39	P.J. Walker	DJ Moore	DJ Moore	#N/A	RB1
Lines

Cell Formulas
Range	Formula
L2:L39	L2	=VLOOKUP(Table9[@MVP],Table16,3,0)
M2:N2,M4:N39,M3	M2	=IFERROR(VLOOKUP(Table9[@FLEX],Table16,3,0),VLOOKUP(Table13[@FLEX],Table2,3,0))
O2:O39	O2	=IFERROR(VLOOKUP(Table9[@FLEX3],Table16,3,0),IFERROR(VLOOKUP(Table13[@FLEX3],Table2,3,0),VLOOKUP(Table13[@FLEX],Table2,3,0)))
P2:P39	P2	=IFERROR(VLOOKUP(Table9[@FLEX3],Table16,3,0),IFERROR(VLOOKUP(Table13[@FLEX3],Table2,3,0),IFERROR(VLOOKUP(Table13[@FLEX],Table2,3,0),Table13[@FLEX2])))

What I have been trying to do is lookup the values in each row until it reaches a blank.(values in table1 are looked up in a separate sheet than values in table 2). Once it reaches a blank, it goes to the next table and looks up the values in that table. The issue I am having is that some rows reach blanks sooner than the next one. I'm kind of wondering if anyone has any suggestions on my dilemma. Thank you for your time.

 

[cspengel]

I've given this some thought and think I know what I need to do. I need to count the blank rows after the text entered. So if row 2 has:

Jim in ColA, Bob in colB, and Sam in Column C out of 5 columns in the table then it needs to return Jim Bob Sam 1 2.

Does that make sense?

Then I could use a nested if to test if each cell contains 1 2 3 4 and if not then perform the vlookup.

How could I auto enter the numbers in the blanks?