Just add the sheet name:

=VLOOKUP($A3,Sheet2!$C$1:$F$12,COLUMNS($A1:A1),0)


--
Biff
Microsoft Excel MVP


"mp" wrote in message
...
The lookup string is looking for data on another worksheet. This formula
didn't work.

"T. Valko" wrote:

Let's assume you enter the first formula in cell A1.

=VLOOKUP($A3,$C$1:$F$12,COLUMNS($A1:A1),0)

Copy across as needed

--
Biff
Microsoft Excel MVP


"mp" wrote in message
...
If I have a vlookup in one cell and I try to autofill across multiple
columns, how do get the column index num reference to increase by one
as I
autofill across. It appears as though the column index number is
always
an
absolute value.

Example
Column A
Column
B
Vlookup($A3,$C$1:$F$12,1,false) Vlookup(($A3,$C$1:$F$12,2,false)