Prev: How can I insert a date which is the first date of the following m
Next: VLOOKUP returns incorrect data
From: Jacob Skaria on 3 Jun 2010 07:42
Another way ..In cell A1 and copy down

=OFFSET($B$1,,ROW())

--
Jacob (MVP - Excel)


"Ana via OfficeKB.com" wrote:

> Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
> corner of a cell. I will automaticly link
> A1 - C1
> A2 - C2
> A3 - C3 ect
>
> My question is if it is possible to drag horisonal and link vertically???
>
> A1 - C1
> A2 - D1
> A3 - E1
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: How can I insert a date which is the first date of the following m
Next: VLOOKUP returns incorrect data