using your format here's the actual formula:
=IF(ISERROR(VLOOKUP($B19,History1!$B$13:$IV$1499,C OLUMNS($S13:S13),FALSE)),"",(VLOOKUP($B19,History1 !$B$13:$IV$1499,COLUMNS($S13:S13),FALSE)))

Problem - no matter what range I put in it always returns the same value.
The info I'm looking for is in S13. The info it's pulling comes from A13.

I appreciate the help.

"T. Valko" wrote:

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)