Replace the 2 with COLUMN() or Column()-n

If data from B (2) is going to column D(4) then use COLUMN()-2 i.e 4-2 =2.
just copy across.

HTH

"Walter" wrote:

I have two worksheets and I can pull the ColB column of data over to where I
want it with vlookup but how can I then get columns C thru G over to my
worksheet? I am trying to pull forecasted prices for the same row of
information. Here is my current function formula: =VLOOKUP(H2,'[-
Master.xls]Pricing'!$A$2:$G$4611,2,FALSE) It would be nice to have the 2
change to a three when I drag the formula to the right. And then drag again
and have the 3 change to a 4, etc. Or what is the answer. Thanks in
advance. The sheet I am pulling data from looks somewhat like this:

ColA ColB ColC ColD ColE ColF
ColG
Part Number Year1 Year2 Year3 Year4 Year5 Year6
XXXX1111 $1.00 $1.25 $1.50 $1.75 $2.00 $2.25