Little Help... Thanks in advance

[GaryG9595]

I have columns A thru Z pulling in V-lookups and I want to pull certain columns of my data from those columns based on the Zero's it finds....
First row might have zero's in columns R thru Z so I want to return column Q in Column AB, then column P in column AC, Then column O in column AD, etc....

Basically I am using this formula
Column AB=IFERROR(OFFSET(A3,0,MATCH(0,A3:Z3,0)-2),"")
Column AC=IFERROR(OFFSET(A3,0,MATCH(0,A3:Z3,0)-3),"")
Column AD=IFERROR(OFFSET(A3,0,MATCH(0,A3:Z3,0)-4),"")

and it works perfectly except it reads from left to right, so if there is a zero mixed in column c it pulls in column b...

Is there a way I can target column Z first then Y, then W, etc.... and go right to left...?

Thanks in Advance

Gary

 

[markmzz]

Hi Gary,

If I understand what you want, so the formula below in AB3 and copy down and to the right can helps.

=IF(OFFSET($Q3,,COLUMNS($AB3:AB3))=0,OFFSET($R3,,-COLUMNS($AB3:AB3)),"")

	A	B	C	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
1
2	Col01	Col02	Col03	Col09	Col10	Col11	Col12	Col13	Col14	Col15	Col16	Col17	Col18	Col19	Col20	Col21	Col22	Col23	Col24	Col25	Col26		Res17	Res16	Res15	Res14	Res13	Res12	Res11	Res10	Res09
3	6	7	1	4	3	5	9	1	3	5	8	3	0	1	9	3	6	7	1	1	0		3								4
4	3	3	0	2	5	5	8	7	2	7	8	8	5	5	7	1	3	4	7	8	4
5	9	2	3	9	7	7	4	6	8	2	6	3	3	0	8	7	7	1	5	9	3			6
6	3	4	9	2	8	1	6	8	3	6	4	8	8	0	6	3	3	5	7	7	3			4
7	7	2	2	5	9	2	1	6	5	3	8	3	9	4	4	6	9	4	9	9	5
8	3	2	2	5	7	1	1	9	2	5	4	6	0	7	8	3	6	2	8	9	3		6
9	8	4	4	5	1	9	6	1	3	6	4	5	3	7	9	1	2	1	2	8	4
10	2	3	2	6	6	7	9	7	5	2	7	3	4	8	9	1	3	7	6	6	6
11	1	6	6	8	7	4	1	8	1	2	2	1	8	7	9	5	7	3	7	3	0										8
12
***																						**										**

<tbody>
</tbody>

Markmzz