Can't figure this out for the life of me...Absolute, Relative, Mixed References

**DallasTigah** · 02-10-2014, 09:51 PM

First time poster. I'm praying that the gods of excelforum.com can bestow some of their infinite wisdom upon me...

So I'm working on a model in which I have for example, the following formula in Tab 1:

=(Tab2!A1)

I want to copy it horizontally but lock ONLY the column and have the rows stay relative. So for example, I want the next cell to look like: =(Tab2!A2).

For some reason, =(Tab2!$A1) does not equate to =(Tab2!$A2) when I copy the formulas horizontally. I'm really hoping that there is a simple fix for this. Any suggestions?

**TMS** · 02-10-2014, 10:00 PM

When you drag across, it is the column that will auto-adjust ... and you've made that absolute, so that's fixed.

You could try:

Formula:

Please Login or Register  to view this content.

Regards, TMS

**DallasTigah** · 02-10-2014, 10:10 PM

Works like a charm -- Thank you TMS

**TMS** · 02-11-2014, 01:20 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.