How do i copy a vlookup formula into other cells going right

[km440]

I have a vlookup formular in one cell, if i copy it downwards in the same
column its giving me the correct values Im looking for, but if i try to copy
it to the right its copying the same values across. I want it to copy the
values that correspond to the cells and not the value of the cell im coping
from. what do i need to do? Please help

 

[Pete_UK]

Well, first of all you can post your formula.

But without that, here are some things to consider:

if you have something like this:

=VLOOKUP(A2,Sheet1!A$1:F$100,2,0)

then when you copy to the right it will become:

=VLOOKUP(B2,Sheet1!B$1:G$100,2,0)

so you will need to anchor the column references in the formula, like
this:

=VLOOKUP($A2,Sheet1!$A$1:$F$100,2,0)

However, you also need the 3rd parameter to change as you copy it
across, and you can achieve this by using the COLUMN function. So,
that formula would become:

=VLOOKUP($A2,Sheet1!$A$1:$F$100,COLUMN(B1),0)

and then you can copy this 4 columns to the right (as the table is
only defined to column F).

Hope this helps.

Pete