drag across, keepletter change number

[ste33uka]

A3 is formula =F1
Hi how can i drag A3 across so that
B3 would be formula =F2
C3 would be formula =F3
and so on
Thanks

 

[Fluff]

How about
=INDEX($F:$F,COLUMN())

 

[gaz_chops]

Try

=INDIRECT("F"&COLUMN(B1))

 

[ste33uka]

Try

=INDIRECT("F"&COLUMN(B1))

Any other ideas ? i thought dragging across and just changing number would be easy

 

[Fluff]

What about post#2?

 

[gaz_chops]

My bad, you're starting in Col A so

=INDIRECT("F"&COLUMN())

 

[ste33uka]

My bad, you're starting in Col A so

=INDIRECT("F"&COLUMN())

Thank you, that done it

 

[gaz_chops]

You're welcome, thanks for the feedback.

 

[Fluff]

Did you try my suggestion in post#2?
It is best to avoid volatile functions like INDIRECT.

 

[ste33uka]

Did you try my suggestion in post#2?
It is best to avoid volatile functions like INDIRECT.

My bad ,both solutuion wont work for me, i think i need the actual cell to say formula
example
B3 would be formula =F2