How do i copy a vlookup formula into other cells going right
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
On Dec 12, 10:28*am, km440 wrote:
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
|