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

 

[ste33uka]

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

Actually that solution works , thanks alot!

 

[Fluff]

My bad ,both solutuion wont work for me

In what way. That really tells us absolutely nothing.
Is this what you want

+Fluff New.xlsm
	A	B	C	D	E	F
1						1
2						2
3	1	2	3	4		3
4						4
Main

Cell Formulas
Range	Formula
A3:D3	A3	=INDEX($F:$F,COLUMN())

 

[gaz_chops]

Both solutions do what you asked for, post a sample showing the results that you expect.