Dragging by keeping the column the same

[marksuza]

Hi,

Can anybody help me? I have created a formula and I want to drag i
horizontally but keeping the same column. I used $G3, but it is no
working.

Thanks for the help.

Marco

 

[JulieD]

Hi Marcos

$G3 works fine for me, could you please copy & paste your exact formula
(from the original cell and from the first cell you drag it to)

Regards
JulieD

 

[marksuza]

original: 2.4%
Drag: ='Bloomberg-Model'!$N3

Thanks Juli

 

[JulieD]

Hi

if in Bloomberg-Model sheet N3
i have 2.4%
when i enter the following formula into sheet3 A1
='Bloomberg-Model'!$N3
and drag it to C1 i see
A B C
1 2.4% 2.4% 2.4%

(once i've formatted it as % - it initially appears as 0.024)

what do you see if you do the same?
or have i completely misunderstood the problem

Cheers
JulieD

 

[marksuza]

Hi guys. No, what I want is for the column to stay the same but rows t
change. ='Bloomberg-Model'!$G3, if I drag this across, I get the sam
thing, the row number does not change. ????

Once again thanks.

Marco

 

[Ragdyer]

Try this:

=INDIRECT("'Bloomberg-Model'!$G"&COLUMN(C1))

And drag across.

Don't worry about the row number (1) in the column function.
Doesn't really mean anything in this context.
Could use any row number you wish.

*BUT* ... I hope you're using this in the same workbook, on a different
sheet, because since this is using Indirect(), "'Bloomberg-Model' *must* be
open

 

[marksuza]

Thanks guys