or this (slightly shorter, same results)
=VLOOKUP($A2,'Sheet2'!$2:$65536,COLUMNS($A2:B2),F ALSE)

Even shorter:

=VLOOKUP($A2,Sheet2!$2:$65536,COLUMNS($A:B),0)


--
Biff
Microsoft Excel MVP


"Cyno" wrote in message
...
Try this, works anywhere on the spreadsheet:
=VLOOKUP($A2,'Sheet2'!$A$2:$IV$65536,COLUMNS($A2:B 2),FALSE)

or this (slightly shorter, same results)

=VLOOKUP($A2,'Sheet2'!$2:$65536,COLUMNS($A2:B2),FA LSE)



"Kia" wrote:

If I have =VLOOKUP(date,data,2) and in the next cell down I want
=VLOOKUP(date,data,5) so the col_index_num increments by 3 each time how
would I go about doing this so that it can be copied down instead of
editing
each line by hand?

Many Thanks in advance