I am trying to take my Vlookup and, when I drag it across my doc, have it increa

Question

I am trying to take my Vlookup and, when I drag it across my doc, have it increaase the column values in the table_array in pairs instead of by one. See examples!:

What it is currently doing:
=IFERROR(VLOOKUP($A2,'Feb VV Data'!A:B,2,FALSE),0)
=IFERROR(VLOOKUP($A2,'Feb VV Data'!B:C,2,FALSE),0)
=IFERROR(VLOOKUP($A2,'Feb VV Data'!C:D,2,FALSE),0)


What I need it to be doing:
=IFERROR(VLOOKUP($A2,'Feb VV Data'!A:B,2,FALSE),0)
=IFERROR(VLOOKUP($A2,'Feb VV Data'!C:D,2,FALSE),0)
=IFERROR(VLOOKUP($A2,'Feb VV Data'!E:F,2,FALSE),0)

Having to maake these changes by hand takees a lot of tiime.

Please Help!!

Explanation / Answer

Hi,

Try this. As written it's the equivalent of

=IFERROR(VLOOKUP($A2,'Feb VV Data'!A:B,2,FALSE),0)

=IFERROR(VLOOKUP($A2,OFFSET('Feb VV Data'!$A:$A,0,(COLUMN(A1)-1)*2,10000,2),2,FALSE),0)

Drag 1 cell right and it becomes

=IFERROR(VLOOKUP($A2,'Feb VV Data'!C:D,2,FALSE),0)

Note you formula is full columns and I avoid this if possible for speed reasons. My version does only 10,000 rows butt you can increasee this if you require by chagnging the 10000 in the formula to a larger number.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.