Copying formulas to the right?

[tu0nie]

I have a quick question. I have some complex forulas that I need to copy to the right but what I need is not working maybe someone can help me. Ill set up and example.
Lets say I have 1 in cell A3 and 2 in cell A4 and so on down through 25 in cell A27. Now I have =$A3 in cell B2 and =$A4 in cell C2. I want to copy those formulas to the right until I get =$A27 in cell Z2. When I copy the formula to the right it give me =$A3 in cell D2 instead of =$A5 & =$A4 in E2 instead of =$A6. Hopefully this all makes sense and there is something easy that I am just missing. Thanks for your time.

[jasoncw]

You can do this using the INDIRECT function. In your example, this will work. In cell B2, use:

=INDIRECT("A"&COLUMN()+1)

Then you can copy it across.

HTH

Jason

[tu0nie]

What is my formula is more complex? Here is my formula. =IF($B77="","",IF((ISNA(VLOOKUP($B77,C$11:P$260,6,FALSE))),$H77,(MAX((DMAX($B$10:$P$260,$O$10,BP$1:BP$2)),$H77)))) Now when I copy this down I want the numbers that dont have $ to increase by one like it does and I want the BP's without the $ to increase 1 column to the right which it does not. This is the same problem with copying to the right. My numbers dont increase then and my columns will move the the next which would be correct. How do I solve this if I want both the numbers to increase and the column to shift to the right as I copy down. I dont have $ infront of them so I thought this should work.

Thanks for your quick response!

[jasoncw]

In which cell is the first formula, and to which cells do you wish to copy?

[tu0nie]

Lets say that formula is in cell D4 and I want to copy it down and get the BP to go to the next column. so D5 would have =IF($B78="","",IF((ISNA(VLOOKUP($B78,C$11:P$260,6, FALSE))),$H78,(MAX((DMAX($B$10:$P$260,$O$10,BQ$1:BQ$2)),$H78)))) and D6 would be BR$1:BR$2 and so on.